Forum Discussion

HalfADimePlural's avatar
New Contributor
6 years ago

Get return value from a stored procedure

I followed the documentation on stored procedures here and I'm able to get my stored procedure to run, but my return value is always 0. I've searched high and low for my problem but no one else seems...
  • RUDOLF_BOTHMA's avatar
    6 years ago

    VERY old post, but the principals are still the same


    Multiple Recordset Stored Procedure



    In ADO however when return multiple recordsets you loop through the
    recordet something like this

    SET Rst = Connection.Execute(procMultipleRst)

    doWhatever1 Rst

    SET Rst = Rst.NextRecordset
    doWhatever2 Rst

    SET Rst = Rst.NextRecordset
    doWhatever3 Rst