Queries is used to experiment with SQL commands that return a dataset. On the left there is the possibility to create SQL commands, using the buttons under the SQL editor "Load Query ..." to load SQL files and save them with "Save Query ..". By means of "Execute Query" the SQL commands in the editor are executed, or acknowledged with an error message, if one did something wrong.

The five buttons on the bottom right hand side contain ready-to-use SQL statements that appear immediately after you click. Above is the table and field names of the two tables used, so you do not have to constantly think, as for example, a particular field is called.

Another button opens the website "w3schools.com" to provide any assistance with SQL commands.

Cheerful testing with the SQL statements ... There will be more to this page later ...

Description ZQuery


© CMBasic.de