Use GetResults to get output params from MSSQL and Sybase

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.

Last Modified: 19-OCT-99