Try OpenEdge Now
skip to main content
Online Help
Introducing Progress DB Navigator : Tasks : Common tasks for supported databases : SQL scripting : Starting the SQL editor
 
Starting the SQL editor
1. When you are connected to a database, you can use one of the following methods to start the SQL Editor:
*Select the database in the Connections view, and then click New SQL Editor from the Connections view tool bar.
If you create a new file in the SQL Editor, the script will not automatically be saved when you exit the editor. For new files, you will not be prompted to save the script when you exit the editor.You can save new scripts by choosing either File > Save As before you exit the editor or Save from the context menu in the SQL Editor.
*Choose Generate Select in SQL Editor from the context menu of the DB Structure view. This option is available when you have a table selected and generates a simple query of all the columns in the table. You can modify the generated code before running it.
*Choose Create Table Script from the context menu of the DB Structure view. This option is available when you have a table selected and generates a table creation script based on the schema of the selected table. You can modify the generated code before running it
*Open an existing file from the Navigator view.
*Open an item in the SQL Editor from the New SQL File wizard. This method creates a script that is a resource in an existing project (and you are prompted to save when you exit the editor).
*Follow these steps:
1. Choose File > New > Other.
2. Select Progress DB Navigator > SQL Editor.
3. Enter the name of a project folder in the Enter or select the parent folder field, and type a script filename in the File name field. The filename must be unique: You cannot enter the name of an existing file. However, you can load the contents of an existing file by selecting Link to file in the file system under the Advanced options.
4. Click Finish.