Active-table-editor
Active Table Editor Menu Items
Menu Items are the building blocks used to create user menus.
Each Menu Item consists of an SQL statement, an icon, and a description. When the user selects a Menu Item, the associated SQL statement is executed and the results are displayed according to the Menu Item configuration.
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
- Vertical Table
- Master Details
- 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
Vertical Table
Master/Details
Linking Master and Details
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
We have more videos on ETL-Tools.com YouTube Channel,
Please take a look and subscribe to stay updated with the latest content.
Confused? Ask question on our ETL Forum