ADODataset without post changed data in client side.

Thread View: borland.public.cppbuilder.database.ado

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Julian Lliteras Tue, 19 Apr 2005 09:00

#783

Author: Julian Lliteras
Date: Tue, 19 Apr 2005 09:00

11 lines
1318 bytes

Hi,

In my app, I retrieve data from SQL Server with TADODataset with +- 2000
rows. I need to modify these records without post them to server. I tryed to
copy data from ADODataset to ClientDataset in a while bucle, but it's not a
nice solution and it's very slow too. There is any manner to read data, and
modify changes only in the client side with ADODataset?


Thanks!
Julian.

Re: ADODataset without post changed data in client side.

#785

Author: Viatcheslav V. Vassiliev
Date: Wed, 20 Apr 2005 06:30

31 lines
2111 bytes

Use TADOConnection. Set TADODataSet->Connection to it, open dataset and then 
set TADODataSet->Connection to NULL. Do it all with client-side cursor and 
you will get disassociated recordset. Or use LockType = ltBatchOptimistic 
and never call UpdateBatch().

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

"Julian Lliteras" <yartax@hotmail.com> �������/�������� � �������� 
���������: news:4264c908@newsgroups.borland.com...
> Hi,
>
> In my app, I retrieve data from SQL Server with TADODataset with +- 2000
> rows. I need to modify these records without post them to server. I tryed 
> to
> copy data from ADODataset to ClientDataset in a while bucle, but it's not 
> a
> nice solution and it's very slow too. There is any manner to read data, 
> and
> modify changes only in the client side with ADODataset?
>
>
> Thanks!
> Julian.
>
>

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads