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