HomeFlySpeed SQL QuerySaving Queries to Connection

Saving Queries to Connection


Hi,

I've been looking at Fly Speed SQL query 2.6.5.5 for a client's Oracle 10g database. The query builder is great but I have some questions about saving queries to the connection.

Is this option saving the query to the database? And if so where? The saved queries seem only to be available to the client machine that saved them and have also sometimes disappeared completely - can anyone shed any light on this?

Many thanks,
Kevin Chadney
Kevin Chadney | email
November 20 2009, 08:14 AM
Dear Kevin,

Thank you for your interest to our software.

For now, all queries are stored in the user's folder, Local Settings\Application Data\ActiveDBSoft\FlySpeed SQL Query\<connection name> folder. You may load them as ordinary *.SQL text files.

We are planning to present the new version with ability to store queries directly in a database in a few months.
Sergey Smagin | email
3 days since original post
Hi Sergey,

file storage would be fine for me if I could select (in Options) the location (the local settings folder is not properly contained in my backup strategy ...); hence I'd suggest to also consider an option to choose the root for connection storage.

Having said that, currently, I created a junction to redirect the storage to where I want it ...

Stefan
Stefan_E | email
9 months, 2 weeks since original post
You may also create a portable installation and install the program among with your queries where you want to. We will make an option to specify location of the saved queries in one of the next minor versions.
Sergey Smagin | email
9 months, 2 weeks since original post
Hello. Thanks for a very nice SQL Query tool. I'm interested in this topic because somehow my queries folder ended up in C:\ root directory. I really don't want to return to the old days where everything was dumped in the root directory! But there is still no way to change the default location.

When the new feature is added, I hope existing connections will dynamically look in the new location once we set it and manually move folders there. Storing queries in a database would be very nice option, but if that will take longer to develop, just being able to set the default folder location is more important for me at the moment.

FlySpeed SQL Query 2.7.14.0
Windows 7 Pro x64
Mike G | email
11 months, 3 weeks since original post
This topic is closed