To create EGL data parts from relational database tables without creating
a separate Web application, do as follows:
- Select File > New >Other....
A dialog is displayed for selecting a wizard.
- Expand EGL and double-click EGL
Data Parts. The EGL Data Parts dialog is displayed.
- Enter an EGL or EGL Web project name, or select an existing project from
the drop-down list. The parts will be generated into this project.
- Select an existing database connection from the drop-down list or establish
a new database connection--
- To establish a new database connection, click Add and
interact with the New Database Connection Wizard. For details on the
kind of input required in a particular field, right click into the field and
press F1.
- For details on editing or deleting a database connection, see Creating,
editing, or deleting a database connection for the EGL wizards.
When a connection is made to the database, a list of database tables
is displayed.
- If you do not want to accept the default EGL file name for data items,
type a new file name.
- In the Select your data field, click on the
name of the table whose columns will help you to declare data parts. To select
multiple tables, hold down the Ctrl key while clicking
on different table names. To transfer the highlighted name or names to the
list of selected tables, click the right arrow.
- For each of the selected tables (on the right), either specify the name
of the EGL record to be created or accept the default name. To remove one
or more tables from that list, highlight the entries of interest and click
the left arrow.
- If you want to include the library part and SQL record parts in the same
file, select the check box.
- Click Next.
- A tab is available for each table. In each tab, select the key field to
use when reading, updating, and deleting individual rows, then click the right
arrow. To select multiple key fields, hold down the Ctrl key
while clicking on different field names. To remove a key field from the list
on the right, highlight the field name and click the left arrow.
- Choose the selection condition field to use when selecting a set of rows,
then click the right arrow. To select multiple fields, hold down the Ctrl key
while clicking on different field names. To remove a field from the list on
the right, highlight the field name and click the left arrow.
- To customize an implicit SQL statement, see Customizing SQL statements
in the EGL wizards. This option is not available for the EGL delete statement.
- Click Next.
- The Generate EGL Data Parts screen is displayed, including
(at the bottom) a list of the files that will be produced:
- To change the name of the EGL project that will receive the EGL parts,
type a project name in the Destination project field or select a project from
the related drop-down list.
- To specify the EGL packages for a specific type of part (data or library),
type a package name in the related field or select a name from the related
drop-down list.
- Click Finish.