Related Queries
Special offer: 50% discount ($1440) for ODataDB Enterprise until June 24, 2024

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:

IDTABLE_SCHEMATABLE_NAMECOLUMN_NAMEEVENT_NAMEHANDLER_SCHEMAHANDLER_NAMEHANDLER_TYPEHANDLER_CODE
 s05usp_order_detailsorder_idSyncParameters05usp_order_headerPROCEDURE
 s05usp_order_headerorder_idSyncParameters05usp_order_detailsPROCEDURE
 s05usp_order_detailsDefaultListObjectATTRIBUTE