The EGL Data Parts wizard lets you create SQL record parts, as well as
related dataItem 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 these files:
- An EGL source file that defines each record part
- An EGL library for each record part
- An EGL source file that contains all the dataItem parts
referenced by the structure items in the SQL record parts
You can reduce the number of files if you select the
Record
and library in the same file check box.