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.
Unfortunately, FlySpeed does not allow automatic links between tables in the query. This is really annoying, do you have plans to add this functionality?
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.
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.
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!
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.
Are all the options in FlySpeed available in Active Query Builder?
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.
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.
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.
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.