EGL Data Parts wizard

The EGL Data Parts wizard lets you create SQL record parts, as well as related data-item parts and library-based function parts, from one or more relational database tables or pre-existing views.

After connecting to the database, you can do as follows:

• Specify the SQL-record key fields that are used to create, read, update, or delete a row from a given database table or view.

• Customize explicit SQL statements for creating, reading, or updating a row. (The SQL statement for deleting a row cannot be customized.)

• Specify the SQL-record key fields that are used to select a set of rows from a given database or view.

• Customize an explicit SQL statement for selecting a set of rows.

• Validate and run each SQL statement

The output includes an EGL source file that contains all the data-item parts referenced by the structure items in the SQL record parts. For each SQL record part, the wizard also produces two files: one for the record part itself, one for the related, library-based functions. You can reduce the number of files, however, if you ask to include each record part in a record-specific library.

Related concepts
SQL support

Related tasks
Creating, editing, or deleting a database connection for the EGL wizards
Creating EGL data parts from relational database tables
Customizing SQL statements in the EGL wizards