To create an SQL query

  1. Start the OpenESQL Assistant.
  2. Connect to a data source.
  3. On the tree view, check the box next to a table name.
  4. On the Select Type of Query to Create dialog box, click a query type from the list.
  5. Check Generate query with FOR UPDATE (SELECT or SELECT DISTINCT queries only) to generate a FOR UPDATE clause in the query. Optional.
  6. Check Generate query with WHERE CURRENT OF (UPDATE or DELETE queries only) to generate a WITH CURRENT OF clause in the query. Optional.
  7. Click OK. The query code appears on the Query tab.
  8. Add tables, columns, search criteria, and auxiliary code to the query as necessary.
Parent topic: OpenESQL Assistant
Related concepts
Select Type of Query to Create dialog box
OpenESQL Assistant
Building Queries
Setting OpenESQL Assistant Options
Stored Procedures
OpenESQL Assistant
Building Queries
Generating initial query code
Related tasks
To add a column to a query
To close a query
To create a table join
To start the OpenESQL Assistant
To remove a table from a SELECT query