I have an app which I've developed which has a sqlite database linked to it. The database is in the same folder as my stack script. All work well within the live code environment. I'm experimenting building a standalone using the community edition (7.0.6). The stack compiles correctly (although it complains regarding an icon I haven't chosen), however when I launch the app on my Mac, it says it can't find the database table. I have a fairly straightforward database connection script which I will list below. My question is, should the standalone builder embed (or copy) the database in my application as?
Logically (well to me) I copied over my sqlite db into the same location as the standalone application, but when I launch the standalone, it still says it can't find the various tables to process
This is my code in the card script of the main card, have UI missed a crucial step somewhere in the building process?
Code: Select all
on openCard
--if gConnID is empty then
put the effective filename of this stack into filepath
set the itemdelimiter to slash
put "mydb.sqlite" into the last item of filepath
put revOpenDatabase("sqlite", filepath,,,,,,) into gConnID
start using stack "CodeLibrary"
start using stack "ObjectLibrary"
createFontMenu
end openCard
Jalz