Re: Delphi sql stored procedures

Posted by webmaster Guido on March 11, 2005

In Reply to: sql stored procedures posted by Frank Verano p12409 on March 09, 2005

In Delphi 7, I am trying to execute a SQL stored procedure.
Should I use TADOStoredProc?
If so, can you give me an example? I am not sure how to use it.

Firstly, which type of database are you using? We have to find out if is ADO the right database engine for your application.

In Delphi, several database engines are available: ADO (ActiveX Data Objexts), DBX (dbExpress), IBX (Interbase Express), BDE (Borland Database Engine),...

Notes:

ADO is a Microsoft technology, that works very well with products such as MS SQL Server and Access. ADO uses the TADOStoredProc component.

DBX is a Borland technology. Borland has dbExpress drivers for Interbase, Oracle, DB2, SQL Server and MySQL.

IBX can only be used for Interbase and FireBird databases.

The BDE is good for local "desktop" databases, such as Paradox and dBase. Note: stored procedures do not apply for these.

Delphi Tutorials -- by DelphiLand