EMS logo

Produits

SQL Query for PostgreSQL

Notre statut de partenariat

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Query for PostgreSQL

Documentation en ligne

Query execution


When all the query parameters are set, you can execute the query in Visual Query Builder.

 

To execute a query, select the Query | Execute main menu item, or use the Execute query iconExecuteQuery button on the main toolbar. You can also use the F9 hot key for the same purpose.

 

The query execution may be interrupted by pressing the Cancel button.

 

Interrupt execution

 

If the query parameters are specified correctly, the query is executed and, in case the query statement is supposed to return data (e.g. as SELECT statement), the Results area containing the returned data appears within the Data tab. The position of the tab depends on the Query results on separate tab option selection (see Environment options | Preferences). If any of the query parameters contain errors, the query execution is stopped and the corresponding error message is displayed in the status bar area at the bottom of the Builder window.

 

By default, data returned by a query are displayed as a grid (see Data View for details).

 

hs3328 - Query execution

 

 

 


See also:

Working with Query Builder area

Joining tables

Setting criteria

Setting output fields

Setting grouping criteria

Setting sorting parameters

Working with the editor area