Delphi32.com - Home!
| Home/News | Downloads | Forums | D32 Magazine | Resources | Info and Facts |  
 
 Using Stored Procedures


How do I use stored procedures in a multi-tier environment?   

    You'll need to get the provider interface and set the parameters before trying to open the client dataset. Unfortunately there is no way to do this at design time, but it should work OK at run time. Here is some code that shows basically what you need to do:

    ?
    procedure TDBClientTest.Button3Click(Sender: TObject); var Params: Variant; begin ClientData.Provider := RemoteServer .GetProvider('ProviderName'); Params := VarArrayCreate([0, ], varVariant); Params[0] := VarArrayOf(['@InParam ', 0 ]); Params[ ] := VarArrayOf(['@InParam2', 'test_param']); ClientData.Provider.SetParams(Params); ClientData.Open; end; ?
    This example assumes the stored procedure takes 2 parameters, and binds them by name. If you need to update the data returned from a stored procedure, you will need to use a TUpdateSQLProvider.

     



  << 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