Selection Change Handlers

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.