Re: GLX2 new feature when working with SQLite databases and database query builder
William, I have just uploaded a new beta to our update server. You and all other licensees can now update to b41. It has several small bug fixes in it, including the restoration of the default folder under any and all circumstances where GLX2 might need to set it. Best, Jerry Daniels Daniels & Mara, Inc. Makers of GLX2 http://www.daniels-mara.com/glx2 On Mar 24, 2008, at 10:16 AM, Jerry Daniels wrote: William, GLX2 set the default folder, but sets it back again. Perhaps this process was interrupted. I'll double check the code to bullet-proof it. Thanks for the report and detective work. Best, Jerry Daniels Daniels & Mara, Inc. Makers of GLX2 http://www.daniels-mara.com/glx2 On Mar 22, 2008, at 5:04 PM, william humphrey wrote: Thanks for the explanation. So GLX2 changed my default folder without notifying me. That's interesting. When it happens and the empty database gets created in there it makes RunRev use nearly all the processor cycles and slow to a crawl. If you use the database query builder then the database has to be in the default folder so thanks very much for the suggestion on setting the defaultFolder. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: GLX2 new feature when working with SQLite databases and database query builder
William, GLX2 set the default folder, but sets it back again. Perhaps this process was interrupted. I'll double check the code to bullet-proof it. Thanks for the report and detective work. Best, Jerry Daniels Daniels & Mara, Inc. Makers of GLX2 http://www.daniels-mara.com/glx2 On Mar 22, 2008, at 5:04 PM, william humphrey wrote: Thanks for the explanation. So GLX2 changed my default folder without notifying me. That's interesting. When it happens and the empty database gets created in there it makes RunRev use nearly all the processor cycles and slow to a crawl. If you use the database query builder then the database has to be in the default folder so thanks very much for the suggestion on setting the defaultFolder. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: GLX2 new feature when working with SQLite databases and database query builder
Sarah
Ignore that question please. I looked it up.
Bill
On Sat, Mar 22, 2008 at 6:31 PM, william humphrey <[EMAIL PROTECTED]>
wrote:
> Can you tell me why specialFolderPath("Documents") has "Documents" in
> there? Is it a way to set that type of folder path as opposed to one that is
> an application for RunRev to use instead of a Document?
>
>
--
http://www.bluewatermaritime.com
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
Re: GLX2 new feature when working with SQLite databases and database query builder
Can you tell me why specialFolderPath("Documents") has "Documents" in there?
Is it a way to set that type of folder path as opposed to one that is an
application for RunRev to use instead of a Document?
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
Re: GLX2 new feature when working with SQLite databases and database query builder
Thanks for the explanation. So GLX2 changed my default folder without notifying me. That's interesting. When it happens and the empty database gets created in there it makes RunRev use nearly all the processor cycles and slow to a crawl. If you use the database query builder then the database has to be in the default folder so thanks very much for the suggestion on setting the defaultFolder. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: GLX2 new feature when working with SQLite databases and database query builder
On Sun, Mar 23, 2008 at 1:26 AM, william humphrey <[EMAIL PROTECTED]> 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
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
GLX2 new feature when working with SQLite databases and database query builder
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. This caused all kinds of problems since it was an empty copy (maybe it should have notified me with an error message). I had to figure this out and move the database from the location where it had been before (and a not very good location but the only place I could get it to work in the past -- inside the application folder for RunRev). Now all my calls using RunRev's built in Database query manager work fine but none of my manual calls which require registering SQLite with a file path that I have been using but not really liking like so: put "/Applications/Revolution_Studio/2.8.1-gm-3/shipping.sqlite" into tDBA["FilePath"] I'd much rather the file path to SQLite was automatic to a nice folder like GLX2 just did for me. So I'm writing this to warn other users of GLX2 about this new feature and I'm hoping someone that knows this stuff will tell me a better way to say put "/Users/administrator/Documents/My\ Revolution\ Studio/Plugins/GLX2\ Work\ Spaces/shipping.sqlite" into tDBA["FilePath"] for the SQLite stuff I'm doing without using RunRev's built in Database Query Builder. Ideally there would just be a call to whatever GLX2 figured out. Thanks and I think GLX2 is great and if I had more time to spend programming and less time urgently needing to use the program I wrote (badly and unfinished) I'm sure I would like it even more. and thanks as always for helping -- Bill PS - and I wish I could go to the RunRev conference and sit in on Trevor's class! ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
