Use GetResults to get output params from MSSQL and Sybase
community.borland.com
Article #10320: Use GetResults to get output params from MSSQL and Sybase
Question: I'm calling a StoredProc on MSSQL or Sybase that returns a result set and other other output parameters. Why do I never get any values in my output parameters?
Answer: For MSSQL and Sybase, parameters are not returned until you go to the end of the result set. You must execute code similar to the following:
with StoredProc1 do begin Open; Last; GetResults; //Retrieve output parameters here end;
For more information on GetResults see TStoredProc.GetResults in Delphi or C++ Builder Help.