f2s_esql_call_func¶
Applies to: Oracle, MS SQL, MySql/MariaDB, PostgreSQL Drivers
Syntax¶
f2s_esql_call_func {function} [with {params}] to {variable}
Parameter |
Description |
|---|---|
function |
Full name of the function |
params |
Optional Parameter(s) to pass to the function (can be multiple) |
variable |
Variable to hold the returned value |
Description¶
This command is used to execute a function stored in the SQL backend. This is an alternative to building a function with the f2s_esql_set_func_name, f2s_esql_set_func_param and f2s_esql_execute_func commands. This command builds and executes the function by setting the full function name, the parameter(s) to pass and the variable to hold the returned value. Note that this command can only return a single value so f2s_esql_set_func_parm and f2s_esql_set_func_name must be used when dealing with multiple return values.
Example¶
string sStatus
integer iCustomerID
move 5 to iCustomerID
f2s_esql_call_func "getCustomerStatus" with iCustomerID to sStatus