This function executes an SQL statement a on the database being represented by alias b. Placeholders in the form of "&parameterNumber" being defined in the statement are replaced by the values of parameters c to j. Characters that are needed for a valid syntax need to be placed in the statement. The number of selected rows is limited to 1 automatically.

If the database returns a result, each column's value is saved to a variable with the name of form "VAR_columnname" with the name being changed to uppercase. The variables must be defined in advance. The result value of the function is the value of the first column. For a variable name prefix other than VAR_ see parameter n. Important note: Regardless of the type with which the variables are defined in the variable dialogue, they are assigned the type String at runtime after the function has been executed. The type is then retained during runtime, even if the variables are used in other functions, for example. However, the type is not changed in the variable dialogue itself.

Is a column being selected of type BLOB, the parameter m allows to specify if the data being selected should be encoded with Base64 before being added to the result list. If m is true, the function performs the encoding and false will leave the data unchanged. If there are no columns of type BLOB, the parameter has no effect.

Important note: In addition to the use of &parameterNumber for parameters it is possible to use the naming scheme for 'prepared statements'. The use of this prevents SQL Injection Attacks and should be preferred.