Related Queries
The SaveToDB add-in lets you place multiple tables on a worksheet, which can share common parameters.
For instance, both order headers and details can use a common parameter, order_id
.
You can link these parameters using the SyncParameter event type in the xls.handlers.
When you change a parameter value in a query, the add-in automatically reloads the synchronized queries.
Use the DefaultListObject event type to specify the default query that displays parameters on the ribbon.
Here’s 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 |