| |
| 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 StoredProc do
begin
Open;
Last;
GetResults;
//Retrieve output parameters here
end; For more information on GetResults see TStoredProc.GetResults in Delphi or C++ Builder Help.
|
|
| Hits/month |
2,500,000+ |
Downloads (Since May 2000) |
7,393,709 |
| Total Files |
6,023 |
| Forum msgs |
7,670 |
| Articles/FAQs |
70+/900+ |
Top Selling Software at Amazon
|