Try OpenEdge Now
skip to main content
Online Help
Introducing Progress DB Navigator : Tasks : Common tasks for supported databases : SQL scripting : Generating SQL queries
 
Generating SQL queries
To automatically generate a SQL query for an individual table:
1. Select a table in the DB Structure view. Right-click to display the context menu.
2. Choose Generate Select in SQL Editor. The SQL Editor opens with a SELECT statement that contains all the columns of the table.
3. Click Execute SQL to execute the query. The results appear in a browse in the SQL Results view.
Note: If you select a table whose field names begin with an underscore (as is the case in a system table), you need to ensure that every field name is enclosed in quotes. Otherwise, the SQL statement fails. You can modify the Progress DB Navigator preferences so that Copy To Clipboard has the Enclose in single quotes option selected to ensure that all field names are quoted.