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.

5 Responses so far.

Post a Comment

Thank you for your comment.

Any request and idea are welcome.

CLICK TO REGISTER