🚀 go-pugleaf

Use server-side cursor - CursorLocation = clUseServer and TableDirect =
true. Call DisableControls()\EnableControls() even if you have no controls
attached. If you need extreme speed, try OLEDB Direct at
http://www.oledbdirect.com

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

"Palmetzhofer Dietmar" <dietmar.palmetzhofer@boku.ac.at> �������/�������� �
�������� ���������: news:3fc8a70e@newsgroups.borland.com...
> I have to insert (or update) lots of datasets in a Access-2000 DB, and
this
> takes a LOT of time. I am doing this by using
> TTable1->Append();
> // set the fieldvalues
> TTable1->Post();
> in a loop. Does anyone know if there is a possibility to use a batch-job
for
> this (i.e. inserting the records in a buffer and posting them in one
step)?
>
> Can somebody explain to me, what the different Execute-Options mean? The
> explanation in the helpfile is not very helpfull for me ...
>
> Thank,
> Didi
>
>