How to Use Selection Change Handlers in SaveToDB

SaveToDB products let you execute handlers on selection change events.

You can use these handlers to display related details or images, for instance.

To add a handler, specify the SelectionChange event type in the xls.handlers table.

Here's an example:

ID	TABLE_SCHEMA	TABLE_NAME	COLUMN_NAME	EVENT_NAME	HANDLER_SCHEMA	HANDLER_NAME	HANDLER_TYPE	HANDLER_CODE	TARGET_WORKSHEET	MENU_ORDER	EDIT_PARAMETERS
	s05	view_orders		SelectionChange	s05	xl_select_order_details	PROCEDURE		_taskpane
	s08	Employees		SelectionChange	s08	EmployeePhotoInWindow	CODE	<SQL code>

In this example, the SQL code is:

SELECT Photo FROM s08.Employees WHERE EmployeeID = @EmployeeID

For more information about output targets, refer to the xls.handlers topic.