Related Queries

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:

IDTABLE_SCHEMATABLE_NAMECOLUMN_NAMEEVENT_NAMEHANDLER_SCHEMAHANDLER_NAMEHANDLER_TYPEHANDLER_CODE
 s05usp_order_detailsorder_idSyncParameters05usp_order_headerPROCEDURE
 s05usp_order_headerorder_idSyncParameters05usp_order_detailsPROCEDURE
 s05usp_order_detailsDefaultListObjectATTRIBUTE

This website is using cookies. By continuing to browse, you give us your consent to our use of cookies as explained in our Cookie Policy.