🚀 go-pugleaf

As ADO documentation (in MSDN) says: "adAffectAll and adAffectAllChapters
are not valid arguments to Delete". In Delphi/BCB this corresponds to arAll
and arAllChapters. TADODataSet::DeleteRecords() has one parameter -
AffectRecords - it is by default arAll.

//------------------------------------------
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)

"Michele Santucci" <michele.santucci.nospam@nospam.celinavio.it>
�������/�������� � �������� ���������:
news:417379d1@newsgroups.borland.com...
> Thank you!
>
> Of course this will work but since I prefer not to mix different ways of
> programming: there's a way to accomplish that by using
> TADODataSet methods?
>
> "Viatcheslav V. Vassiliev" <support@oledbdirect.com> ha scritto nel
> messaggio news:417155f1$1@newsgroups.borland.com...
> > If you need to delete all records in table, it is usually more effective
> to
> > execute DELETE FROM TableName SQL command, for MS Access - DELETE * FROM
> > TableName, for MS SQL Server TRUNCATE TableName.
> >
> > //------------------------------------------
> > 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)
> >
> > "Michele Santucci" <michele.santucci@celinavio.it> �������/�������� �
> > �������� ���������: news:41711cac@newsgroups.borland.com...
> > > I have a form showing up a table content by data-aware components
> > connected
> > > to a dataset I have to empty the underlying table and so I tought tou
> use
> > > DeleteRecords method.. but If I try I got an exception of this kind:
> > >
> > > Project Environment.exe raised exception class EDatabaseError with
> message
> > > 'Operation not permitted in the current context'. Process stopped. Use
> > Step
> > > or Run to continue.
> > >
> > > The 'faulty' code is that:
> > >
> > >         dmEnvironmentData->adodsEnvironment->DisableControls();
> > >         dmEnvironmentData->adodsEnvironment->DeleteRecords();
> > >         dmEnvironmentData->adodsEnvironment->EnableControls();
> > >
> > >
> > > -- 
> > >
> > >    bye by(t)e[z]....TuX!
> > >
> > >
> >
> >
>
>