SQLReturnValue - cSQLStatement

Get a stored function return value.

Type: Function
Return Data Type: String

Syntax

Function SQLReturnValue Returns String

Call Example

Get SQLReturnValue to StringVariable

Description

This function retrieves the return value of a stored function. Return values are commonly used to indicate success or failure of a stored function. If the module you are calling does not have a return value, i.e. it is a procedure, no error will be generated and the return value will be returned as an empty string.

See the StoredProcedureMSSQL.vw and StoredProcedureODBC.vw views in the Specializd Components sample workspace for samples of calling a stored procedure.

Return Value

This function retrieves the return value of a stored function. If the module you are calling does not have a return value, i.e. it is a procedure, no error will be generated and the return value will be returned as an empty string.