Re: Delphi 6 - ADO - MS SQL Server

On Thu, 21 Sep 2006 16:04:33 -0400, Dennis Passmore
<dennisp@xxxxxxxxxxxxxxxxxxxx> wrote:

I have had similar experience with trying to use
TADOStoredProc as it is a total waste of time.

Executing MsSQL TSQL using

ADOCommand1.CommandText :=
and
ADOCommand1.Execute

is always much better.


And pre-storing the procedures permanantly inside the database to
begin with and then just calling them is even better. We have all of
our MSSQL business logic in stored procedures in the database. Then
our apps just supply the parameters in the calls, which we do either
through AdoConn.Execute or AdoQuery.Execute.
Works really good and isolates the database logic from the
applications.

.