🚀 go-pugleaf

TADODataSet should be used for queries that return rows. Affected rows for
such queries is usually unknown. On client-side cursor you may use
RecordCount, on server-side - traverse with Next() until Eof.

TADOCommand has RecordsAffected as one of parameters in Execute method.

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)

"Arnie Mauer" <xxx@nowhere.net> �������/�������� � �������� ���������:
news:40b4e428$1@newsgroups.borland.com...
> A question along similar lines.  I wonder why TADOQuery has a RowsAffected
> property for UPDATE and DELETE but neither TADOCommand or TADODataSet
does?
>
> - Arnie
>
> "Viatcheslav V. Vassiliev" <support@oledbdirect.com> wrote in message
> news:40b4be84$1@newsgroups.borland.com...
> > TADOQuery was created as replacement for TQuery and has
properties/methods
> > similar to TQuery and TADODataSet - as component for ADO - for example,
> > property CommandText (WideString) instead of SQL (TStrings). TADOQuery
is
> > for recompiling applications from BDE to ADO with minimal changes, but
if
> > you start new project, TADODataSet is closer to ADO.
> >
> > //------------------------------------------
> > Regards,
> > Vassiliev V. V.
> > http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
> > ADO.Net
> > http://www.oledbdirect.com - The fastest way to access MS SQL Server,
> > MS Jet (Access) and Interbase (through OLEDB)
> >
> > "Simon Elliott" <Simon at ctsn.co.uk> �������/�������� � ��������
> ���������:
> > news:40b49888$1@newsgroups.borland.com...
> > > On 26/05/2004, Viatcheslav V. Vassiliev wrote:
> > > > You can use TADOConnection and TADOQuery (or better, TADODataSet).
> > >
> > > What are the advantages of using TADODataSet rather than TADOQuery?
> > > -- 
> > > Simon Elliott    http://www.ctsn.co.uk
> >
> >
>
>