Related Queries
The SaveToDB add-in allows placing several tables on a worksheet.
Such tables can have common parameters.
For example, order headers and details can have a common parameter order_id.
You can link parameters using the SyncParameter event type in the xls.handlers.
When you change a parameter value of a query, the add-in also reloads sync queries.
Use the DefaultListObject event type to set the default query used to show parameters on the ribbon.
Here is a sample configuration:
| ID | TABLE_SCHEMA | TABLE_NAME | COLUMN_NAME | EVENT_NAME | HANDLER_SCHEMA | HANDLER_NAME | HANDLER_TYPE | HANDLER_CODE |
|---|---|---|---|---|---|---|---|---|
| s05 | usp_order_details | order_id | SyncParameter | s05 | usp_order_header | PROCEDURE | ||
| s05 | usp_order_header | order_id | SyncParameter | s05 | usp_order_details | PROCEDURE | ||
| s05 | usp_order_details | DefaultListObject | ATTRIBUTE |