Delphi32.com - Home!
| Home/News | Downloads | Forums | D32 Magazine | Resources | Info and Facts |  
 
 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.  



  << Previous Faq     Complete List     Next Faq >>  



 
 Hits/month  2,500,000+ 
 Downloads
 (Since May 2000)
 7,393,709 
 Total Files  6,023 
 Forum msgs  7,670 
 Articles/FAQs  70+/900+ 
Kylix
Tips n Tricks
FAQs
Knowledge Base
Bug Listings
Articles
Books
Newsgroups
Links
Submissions
Testimonials
Advertising
Contact Us
About Us
Search Amazon:
Top Selling Software at Amazon

| Home/News | Downloads | Forums | Resources | Info and Facts | Testimonials |
  Site Search:
 


Comments/Problems: Webmaster@delphi32.com
Copyright © 1998-2006, Delphi32.com. All rights reserved.
Terms of Use