SQLGetArguments Command

SQLGetArguments

Obsolete

Refer to the SQLGetArgument method in the cSQLStatement class.

SQLGetArguments hstmt [Arg1…] [To Retval]

The SQLGetArguments command can be used for back ends that return the out arguments and return value of a stored procedure as the last result set.

Example Usage

SQLConnect "MSSQLDRV" "SERVER=(local);Trusted_Connection=yes;DATABASE=Order" To hdbc
SQLOpen hdbc To hstmt
SQLCall hstmt "sp_MonthlyBatch" nTotalAmount To iRetval
Move False To bNoMoreSets

Repeat
    SQLStmtAttribute giHstmt SQLSTMTATTRIB_COLUMNCOUNT To iNumColumns
    If (iNumColumns) Begin
        SQLFetch hstmt
        While SQLResult
            For iCount From 1 To iNumColumns
                SQLGetData hstmt iCount To sColValue
                Show sColValue
                If (iCount < iNumColumns) ;
                    Show ", "
            Loop
            Showln
            SQLFetch hstmt
        Loop
    End
    SQLNextResultSet hstmt
    If (Not(SQLResult)) ;
        Move True To bNoMoreSets
Until bNoMoreSets

SQLGetArguments hstmt nTotalAmount To iRetval
Showln "Total amount: " nTotalAmount
Showln "Retval is   : " iRetval