I was working thought this lesson on mySQL http://lessons.livecode.com/m/4069/l/56 ... e-database and am quite perplexed by the whereabouts of the sqlite database.
Currently I am testing on a Mac using Livecode 8.0.2 rc-3
I define the dbName and location as via
Code: Select all
put specialFolderPath("documents") & "/runrevemails.sqlite" into tDatabasePath
Code: Select all
/Users/stewartlynch/Documents/runrevemails.sqlite
To make matters even more peculiar, when I build the app as a standalone, and run it, it also works.
I have discovered here, that the database is created in the apps package contents and is simply called dDatabasePath
This is all very troublesome, because I want to build an app with a predesigned sqlite database that I want my app to be able to open from a defined path yet I cannot figure out why a) I can't find the database when in development mode, and b) why the database has a different name (the variable name) and is in the application bundle when I build as a standalone.
Can anyone shed any light on this?