Please enable JavaScript to view this site.


Navigation: Appendices > Q++Studio > Administration > Database Querying

Using the Visual Query Builder To Write SQL

Scroll Prev Up Next More
To launch the SQL query builder, and create SQL scripts visually, click on the build query button at the top of the database query dialog, as shown in the image on the right.


Make sure to select the desired database, before clicking on the build query button.


After clicking on the build query button, the SQL Query Builder dialog appears, displaying the list of available tables, for the database selected, on the left, and an incremental list of the fields selected, on the right.



The SQL Query Builder dialog, which then opens up, is composed of 2 parts.


At the top of the dialog is a visual query builder component which lets you build complex SQL queries via an intuitive visual query building interface.

At the bottom of the dialog is an SQL editor which displays the SQL script generated by the configuration of the visual query builder component, above it.


Once you have finished construction your query, click on the Select button to copy back the generated SQL script to the database query dialog.


Topic 182615, last updated on 03-Sep-2020