Posted by webmaster Guido on March 11, 2005
In Reply to: sql stored procedures posted by Frank Verano p12409 on March 09,
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),...
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.
The BDE is good for local "desktop" databases, such as Paradox and dBase.
Note: stored procedures do not apply for these.