Database Help Framework Functions

Database Help Framework Functions

FunctionDescription
doc.get_escaped_parameter_nameThis function returns an escaped parameter name.

doc.get_escaped_parameter_name

This function returns an escaped parameter name.

ParameterDataTypeComment
Resultnvarchar(255)Escaped parameter name
@namenvarchar(128)Column name

The function converts special characters using the _xHHHH_ format, where HHHH is the hexadecimal character code.

For example, it converts a single quote to _x0027_.

You may use such parameter names in the procedures and handlers that get values from the Excel table columns.
The SaveToDB add-in uses the same conversion function to link columns and parameters.