Creating EGL data parts from relational database tables

To create EGL data parts from relational database tables without creating a separate Web application, do as follows:

1. Select File > New >Other.... A dialog is displayed for selecting a wizard.

2. Expand EGL and double-click EGL Data Parts. The EGL Data Parts dialog is displayed.

3. 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.

4. 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.

5. If you do not want to accept the default EGL file name for data items, type a new file name.

6. 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.

7. 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.

8. If you want to include the library part and SQL record parts in the same file, select the check box.

9. Click Next.

10. 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.

11. 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.

12. To customize an implicit SQL statement, see Customizing SQL statements in the EGL wizards. This option is not available for the EGL delete statement.

13. Click Next.

14. The Generate EGL Data Parts screen is displayed, including (at the bottom) a list of the files that will be produced:
    1. 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.

    2. 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.

15. Click Finish.

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

Related tasks
Creating a single-table EGL Web application
Creating, editing, or deleting a database connection for the EGL wizards
Customizing SQL statements in the EGL wizards