Re: TADOStoredProc


Hi,

I'm not sure what you mean by "do not match up well"? We have a large client
suite that excusively uses TADOQuery and TADOStoredProc components for
database access. We don't appear to have any problems with the components
and they are easy-to-use.

For instance. TAdoQuery sets the SQL using a Tstringlist while TadoDataset uses
a Widestring;
While both can set the SQL in the underlying ADO dataset there is a performance
penalty if you set it one line at a time like AdoQuery.sql.Add('this line');
leads you to do
--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.

Relevant Pages

  • Re: Truncated Blob Field in TADOQuery
    ... I used a TADOStoredProc instead and the problem went away. ... suspect that ti has to do with the manner in which TADOQuery handles ... and pumping it down into a MS SQL db locally. ... > of the parameter in the TADOQuery component before calling the ExecSQL ...
    (borland.public.delphi.database.ado)
  • Re: MSAccess and ADO
    ... database I use TADOQuery and SQL ... Stanko. ...
    (borland.public.delphi.database.ado)
  • Re: Which is faster??
    ... SQL inserts will always run faster that opening an entire table and posting. ... If you are using MS Access, TADOQuery should be faster, but not by much. ... using TADOTable components and essentially the code looks like this... ... change to INSERT and UPDATE SQL queries be faster?? ...
    (borland.public.delphi.database.ado)
  • Re: the dbgrid will be uneditable
    ... only sqlserver tables and the program running in delphi can generate that ... >>if using tadoquery and sql to join two tables,the dbgrid will be ...
    (borland.public.delphi.database.ado)
  • Re: TADOStoredProc
    ... TadoStoredProc and TadoQuery are intended to match up with the properties ... TadoCommand do. ...
    (borland.public.delphi.database.ado)