Hello
I want to include an sqlite DB in my standalone
In the standalone settings I added the file which is on my desktop. When I start livecode it imports the file, but not the table in the DB. (size is zero bytes)
any ideas?
Thanks
standalone settings
Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller
Re: standalone settings
Hi geo,
1. you need to make sure that your database file is part of your Android APK.
Maybe this is not the case? If in doubt copy the db file to the folder with your stack,
and then add it in the "Stanadlone Application Settings" from there
2. On the phone you will find it here: spcecialfolderpath("resources") & "/name_of_db.db"
3. BUT, yes a BIG BUT, we are not allowed to write in that folder and even opening a database is considered "writing"!
So you need to copy the db file first to the users documentes folder and open it there.
See this posting of mine with an example script how to do this:
viewtopic.php?f=7&t=34964&p=198823&hili ... id#p198607
Best
Klaus
1. you need to make sure that your database file is part of your Android APK.
Maybe this is not the case? If in doubt copy the db file to the folder with your stack,
and then add it in the "Stanadlone Application Settings" from there
2. On the phone you will find it here: spcecialfolderpath("resources") & "/name_of_db.db"
3. BUT, yes a BIG BUT, we are not allowed to write in that folder and even opening a database is considered "writing"!
So you need to copy the db file first to the users documentes folder and open it there.
See this posting of mine with an example script how to do this:
viewtopic.php?f=7&t=34964&p=198823&hili ... id#p198607
Best
Klaus
Re: standalone settings
Thanks Klaus, got the DB in the right place now