Customizing SQL statements in the EGL wizards

When you are at the second screen in an EGL wizard for creating data parts from a relational table or for creating a Web application from a relational table, you can change the SQL statement that is associated with an action like read or update:

1. Select an action from the Edit actions list, then click Edit SQL.

2. Edit the SQL statement (as is possible for all actions except delete), then click Validate. Validation ensures that the statement has the correct syntax and adheres to the rules for host variable names. If the statement contains errors, a message is displayed. Correct the errors and validate again.

   Revert to Last changes the statement into its last valid modified version. Previous versions become unavailable after you close the dialog.

3. Click Execute, then click Execute again.

4. If the SQL statement requires values for host variables, the Specify Variable Values dialog is displayed. Double-click the Value field to enter the value of a host variable, then press the Enter key. When you have entered values for all host variables, click Finish.

   Note: For host variables defined as type character, enclose the value in single quotes.

Related concepts
EGL Data Parts wizard
EGL Data Parts and Pages wizard
SQL support

Related tasks
Creating a single-table EGL Web application
Creating EGL data parts from relational database tables
Creating, editing, or deleting a database connection for the EGL wizards
Setting EGL preferences