Dear Ender,
The program is for iPhone or iPad.
I already have a special folder for the database...
put specialFolderPath("documents") & "/Fish.sqlite" into tDatabasePath
The database has the names (not file paths) of all the photos in one column, and thumbnails in another column. Not blobs.
The other columns hold information about the fish that applies to the photo in that row, such as colour, size, depth etc and data for a quiz.
The photos and thumbnails are in the card "images" of the stack "Resources" at the moment. That obviously has to be changed.
They are copied in the bundle to the device inside the "images" card of the "Resources" stack.
The line...
put line x of databaseGetPhoto() into field "Photo" of card "showPhoto"
is part of a paragraph.
The information about colour, size, depth etc for line x of the database is all called at the same time to display the photo of the fish
and the information about it on the same page.
This line actually puts the image from the card "images" in the stack "Resources" into a field called "Photo".
"databaseGetPhoto()" holds all the photo names on separate lines which are accessed by looking for line x.
The headings of the database are....
put "CREATE TABLE Fish (id int(230), icon char(20), photo char(20), name char(20), propername char(40), colour char(20), size char(10), danger char(20), food char(30), found char(30), credit char(20), wiki char(20), question char(200), qA char(50), qB char(50), qC char(50), answerA char(15), answerB char(15), answerC char(15))" into tSQL
revExecuteSQL tDatabaseID, tSQL
For example, line 1 of the database is...
put "INSERT into Fish VALUES ('1','AngelfishAtie.png','AngelfishAtieb.png','Angel Fish','Emperor angelfish','Blue and yellow','50 cm','No danger','Algae, invertebrates and sponges','Depth up to 70m, by coral reefs and seagrass','Atie Bruinenberg','
http://en.wikipedia.org/wiki/Pomacanthidae','1. What does a thumbs up signal mean?','A: This is good.','B: Are you OK?','C: Shall we go up?','No, try again','No, try again','Correct');" into tSQL
The large photos and the thumbnails are held in the second and third columns.
Is there a way to copy the images from "engine" to the card "images" in the stack "Resources" ?
I hope the above is clear!!
Thankyou for helping.
With best wishes,
Jessamy.