Forum Discussion

HalfADimePlural's avatar
HalfADimePlural
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
    RUDOLF_BOTHMA
    6 years ago

    VERY old post, but the principals are still the same

     

    Multiple Recordset Stored Procedure

     

    Specifically:

    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