GLX2 new feature when working with SQLite databases and database query builder

[Sarah Reichelt]

On Sun, Mar 23, 2008 at 1:26 AM, william humphrey <shoreagent at gmail.com> wrote:
> I just changed the subject
>  I just updated to GLX 2.1b40 and it did something (automatically) that I
>  realize now is very cool but which caused me some consternation.  It made a
>  GLX2 Work Spaces folder in the "My Revolution Studio" folder and put an
>  empty copy of my SQLite database there.

GLX2 creates that folder, but there is no reason for it to move your
database. I expect what happened was that the defaultFolder was
changed to this workspaces folder and your database was saved assuming
the defaultFolder was the same as before. Looking at the oath your
were using before, it appears that you were always using the default
folder as the database was being saved in your Revolution application
folder.

How about when creating and using your database, you specify the path
yourself, and put it somewhere more logical e.g. Documents folder,
Preferences folder, Application Support folder (I don't know what the
database is for, so you will have to decide the location yourself).

Try something like this:
    put specialFolderPath("Documents") & "/shipping.sqlite" into
tDBA["FilePath"]

Or if you want to use the defaultFolder:
    set the defaultFolder to specialFolderPath("Documents")

If you use the defaultFolder method, you need to make sure it is set
each time, as any other stack or plugin might have changed it.

HTH,
Sarah