Page 1 of 1

Using Sqlite Database with Standalone

Posted: Fri Dec 25, 2009 7:15 am
by James Little
I am pleased that I can use a Sqlite Database with a stack in the IDE, using the Query Builder. It even works when I run an Os X standalone on my computer. If I run the Os X standalone on my wife's computer or on my son's computer, the application cannot find the sqlite database, even though I copy the database with the application.

In the Standalone Application Settings, I use the Copy Files tab to copy the referenced database into a folder "Documents". This folder is at the same level as the application in the OS X bundle. I've tried manually moving the database file around in the bundle but in none of the locations does the application find the database.

Any advice?

Thank you.

Jim Little

Re: Using Sqlite Database with Standalone

Posted: Tue Jan 05, 2010 10:32 pm
by Janschenkel
The problem is that the Query Builder stores the full path to the SQLite database file; so once you move the application to adifferent com=puter, and don't place it in exactly the same spot, it won't find the file.

Look at this topic for more information on how to dynamically alter the 'Host' database location for all automated queries.

HTH,

Jan Schenkel.

Re: Using Sqlite Database with Standalone

Posted: Wed Jan 06, 2010 3:38 am
by James Little
Jan,

Thanks so much for the guidance. I will give it a try.

Jim Little