OnParameterSqlStatementConstructed

Called after a parameter dropdown object is constructed. Allows for modifying the object SQL.

Signature     

For custom code the args array is structured as follows:

args[] contains one object, the SQL string which is passed to the server to construct the parameter dropdown.

For .Net Assemblies the method signature is as follows:

string EventHandlerName(SessionInfo sessionInfo, string sqlStatement)

Expected Return

The event expects a string return value: The (modified) SQL statement to be passed to the server to construct the parameter dropdown.

Example

// Orders dropdowns as descending
string sql = args[0].ToString();
return sql.Replace("asc", "desc");