Selection Change Handlers

SaveToDB products allow executing handlers on selection change events.

You can use such handlers, for example, to show related details or images.

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

For 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>

where the SQL code is

SELECT Photo FROM s08.Employees WHERE EmployeeID = @EmployeeID

See details about the output targets in the xls.handlers topic.