Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Product Manuals » ElevateDB Version 2 Manual for RAD Studio 2010 (Delphi) » Using ElevateDB » Executing Stored Procedures |
begin with MyDatabase do begin DatabaseName:='AccountingDB'; Database:='Accounting'; Connected:=True; end; with MyStoredProc do begin DatabaseName:='AccountingDB'; StoredProcName:='GetLedgerEntries'; Active:=True; end; end;
begin with MySession do begin SessionName:='Remote'; SessionType:=stRemote; RemoteAddress:='192.168.0.2'; Active:=True; end; with MyStoredProc do begin SessionName:='Remote'; DatabaseName:='Accounting'; StoredProcName:='GetLedgerEntries'; Active:=True; end; end;
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". |
begin with MyDatabase do begin DatabaseName:='AccountingDB'; Database:='Accounting'; Connected:=True; end; with MyStoredProc do begin DatabaseName:='AccountingDB'; StoredProcName='UpdateLedgerEntries'; Prepare; ParamByName('AccountNo').AsString:='00100'; ExecProc; end; end;
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 |