Do you have a comparison between FlySpeed and Active Query Builder?

Avatar
  • updated
  • Completed

Please provide a comparison between your two products.

Avatar
Anonymous
Active Query Builder is a component for software developers. FlySpeed SQL Query is an end-user database tool.
Avatar
Kelly

Are all the options in FlySpeed available in Active Query Builder?

Avatar
Anonymous

Active Query Builder is a component for programmers who would like to develop a database tool like FlySpeed SQL Query. Active Query Builder is intended to build SQL queries visually, to parse, analyze and modify them programmatically. It does not work with data in any way.

FlySpeed SQL Query is built using Active Query Builder. You may see Active Query Builder in FlySpeed SQL Query at the Query tab above the SQL text editor. FlySpeed SQL Query uses most of the Active Query Builder features, but not all of them, because not all of them are needed in this tool.

Most probably if you do not understand the difference between these products, you need FlySpeed SQL Query.

Avatar
Bruno Lailler
Unfortunately, FlySpeed ​​does not allow automatic links between tables in the query. This is really annoying, do you have plans to add this functionality?


Avatar
Anonymous

This functionality already exists in the tool. It might not work in case of incorrect connection settings. Check that your Connection Type/SQL Syntax settings are set accordingly to your database server. Click the "More options..." button, switch to Advanced tab and check the "Create joins automatically" option.

Avatar
Bruno Lailler

Ok, I use an Generic ODBC connection because the Sybase driver doesn't exists and the "create joins automatically" option is correct : "Create from foreign keys" and it doesn't works.

Avatar
Bruno Lailler
I solved my problem by using a generic ADO connection and a connection string, I found correctly my links between my tables with foreign keys. Thank you for your help!


Avatar
Anonymous

Active Query Builder is a component for programmers who would like to develop a database tool like FlySpeed SQL Query. Active Query Builder is intended to build SQL queries visually, to parse, analyze and modify them programmatically. It does not work with data in any way.

FlySpeed SQL Query is built using Active Query Builder. You may see Active Query Builder in FlySpeed SQL Query at the Query tab above the SQL text editor. FlySpeed SQL Query uses most of the Active Query Builder features, but not all of them, because not all of them are needed in this tool.

Most probably if you do not understand the difference between these products, you need FlySpeed SQL Query.