Please enable JavaScript to view this site.

ESL Documentation

Navigation: » No topics above this level «

SQL Statement Menu Keys

Scroll Prev Top Next More

Use these keys to select choices in the SQL Statement menu.

Ctrl+N

New. Creates a new statement and adds it to the current SQL Access Module (SAM).

Ctrl+P

Open. Opens an existing SQL statement.

Ctrl+T

Tables. Lets you select tables and columns from the current database for inclusion in the current SQL statement.

Ctrl+W

 

Where. Creates a WHERE clause.

Ctrl+J

Join. Creates a join clause between two selected tables.

Ctrl+G

Group by. Creates a GROUP BY clause.

Ctrl+R

Order by. Creates an ORDER BY clause

F6

Run. Dynamically runs the current SQL statement.

Ctrl+V

Link variables. Link ESL variables with selected output columns or SQL statement input parameters.