GET_PROCEDURE_RETURN¶

Applies to: SQLFlex

This command is used to get a returned value from a stored procedure using MSSQL. Note that this command can only handle one returned value and must be used after the procedure has already been built and executed.

Syntax

GET_PROCEDURE_RETURN to {variable}

Parameter

Description

variable

Variable to hold the returned value

Example

SQL_SET_PROCEDURE_NAME "sys.sp_spaceused" NUMPAR 1
SQL_SET_PROCEDURE_PARAMETER 1 to "Customer" IN
SQL_PROCEDURE_EXECUTE
GET_PROCEDURE_RETURN to sSpaceUsed
Showln sSpaceUsed