Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Product Manuals » ElevateDB Version 2 Manual for RAD Studio 10.3 (C++ Win64) » Using ElevateDB » Executing Stored Procedures |
{ MyDatabase->DatabaseName="AccountingDB"; MyDatabase->Database="Accounting"; MyDatabase->Connected=true; MyStoredProc->DatabaseName="AccountingDB"; MyStoredProc->StoredProcName="GetLedgerEntries"; MyStoredProc->Active=true; }
{ MySession->SessionName="Remote"; MySession->SessionType=stRemote; MySession->RemoteAddress="192.168.0.2"; MySession->Active=true; MyStoredProc->SessionName="Remote"; MyStoredProc->DatabaseName="Accounting"; MyStoredProc->StoredProcName="GetLedgerEntries"; MyStoredProc->Active=true; }
Method | Usage |
ExecProc | Use this method when the procedure specified in the StoredProcName property may or may not return a result set. The ExecProc method can handle both situations. |
Open | Use this method only when you know that the procedure specified in the StoredProcName property will return a result set. Using the Open method with a procedure that does not return a result set will result in an EDatabaseError exception being raised with an error message "Error creating table handle". |
{ MyDatabase->DatabaseName="AccountingDB"; MyDatabase->Database="Accounting"; MyDatabase->Connected=true; MyStoredProc->DatabaseName="AccountingDB"; MyStoredProc->StoredProcName="UpdateLedgerEntries"; MyStoredProc->Prepare(); MyStoredProc->ParamByName("AccountNo").AsString="00100"; MyStoredProc->ExecProc(); }
This web page was last updated on Thursday, November 16, 2023 at 10:39 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |