Code completion is provided in the SQL and Command windows, and is designed to help you write SQL faster by trying to complete what your typing.

The completion window appears for three typical areas:

• All Object - This is when your typing in the SQL editor.

  For Example: If you typed "Select * from Cus" then paused would see and drop-down list of all database objects that start with "Cus". Keep typing while the list is still visible, "Customers" and the list is then shortened to only show database objects that start with "Customers".

  The database objects show in the list are Tables, Views, and Procedures.

  

• Field Objects - This is when you type a "." in the SQL editor after a table name or table alais.

  For Example: If you typed "Select * from customers where customers." or "Select * from customers c where c." then paused would see and drop-down list of all fields in the table. Keep typing while the list is still visible, "Co" and the list is then shortened to only show fields that start with "Co".

  

• Param Objects - This is when you type a "(" or "," in the SQL editor after a procedure name.

  For Example: If you typed "CustOrdersDetail(" then paused would see and drop-down list of all parameter required for this procedure in the order they are required. Keep typing while the list is still visible, and the list is then shortened to only show parameters that start with that. After typing the parameter type a "," for the next parameter, and the list of parameters will be displayed again.

  

Note: For the above examples to work the tables and procedures must exist in the database your connected to.

© 2002 Netlegger Systems. All rights reserved.