Active-table-editor
Menu Items
Menu Items are the construction blocks used to design user menus. In other words, the Menu item is a result of the execution of SQL statement associated with the Icon and appropriate Description.
Note: Please always remove comments from SQL
The parameters are called <PARAMETER_1> and
Note: To refresh the screen enter the value and press enter
Menu items’ types
- Table
- Record
- Table/Record
- Report
Table Item
Record Item
Table/Record Item
Using Database Lookup
Note: The first field is a lookup key the second is a lookup value
Report Item
Note: Additional information is provided in a separate help file
Report design can be changed within the items list or with the item itself
Form Designer - Grid
Form Designer - Record
Report Designer
Video Tutorials
Confused? Ask question on our ETL Forum
Last updated: August 1, 2022
On this page