Configuring Context Menu

Configuring Context Menu

DBEdit allows adding items into the context Actions menu.

For example:

DBEdit - Configured Context Menu Sample

To add menu items, add records into a handler configuration table like xls.handlers with the ContextMenu event type.

For example:

Sample of Context Menu Handlers

You may see the s02.usp_cash_by_months_change procedure defined for the s02.usp_cash_by_month procedure.

The context menu contains a translated menu item, Details. See Data translation for details.

The stored procedure of this sample has the following header:

CREATE PROCEDURE s02.usp_cash_by_months_change
    @column_name nvarchar(255)
    , @cell_number_value money = NULL
    , @section int = NULL
    , @item_id int = NULL
    , @company_id int = NULL
    , @year int = NULL

The procedure gets the active cell column name and value, values from the hidden table columns, and a value of the year parameter.

So, it can select details for any report cell.

Context Parameters

Context menu handlers can use the following context parameters:

Parameter NameValue
@DataLanguage or @data_languageA data language code selected using the Options dialog box
@TableName or @table_nameA qualified name of the active query object like [s02].[usp_cashbook]
@ColumnName or @column_nameThe active column name
@CellValue or @cell_valueThe active cell text value
@CellNumberValue or @cell_number_valueThe active cell number value
@CellDateTimeValue or @cell_datetime_valueThe active cell datetime value
@WindowsUserName or @windows_user_nameThe Windows login of the current user
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.OK