Главная страница | назад

Article #10320: Use GetResults to get output params from MSSQL and Sybase

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?

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
  //Retrieve output parameters here

For more information on GetResults see TStoredProc.GetResults in Delphi or C++ Builder Help.

Last Modified: 19-OCT-99