Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


ID: 19935, ClientDataSet with incremental refresh

by adrian gallero Email: Anonymous


This is a very simple ClientDataSet descendant, allowing to make an incremental refresh from the data on another ClientDataSet
Download Details
FTP  download also available
CDN Login Required to Download. (You will be redirected to the login page if you click on the Download Link)
To download this, you must have registered:
A free membership

For Delphi, Version 5.0  to 7.0 506 downloads
Copyright: No significant restrictions


Size: 2,710 bytes
Updated on Thu, 08 May 2003 06:34:39 GMT
Originally uploaded on Thu, 08 May 2003 06:34:44 GMT
SHA1 Hash: 63A08C803D52C6F13F97F62DCA965AA05CEA346E
MD5 Hash: 6906D2FBF250F3A90922908E11CB0CEA

    Explore the files in this upload

Description
This is a very simple ClientDataSet descendant, allowing to make an incremental refresh from the data on another ClientDataSet

If you have for example a standard ClientDataSet (CDS1) with 1000 records, calling refresh will erase all the data and fetch it again from the server.

If you have a way to know wich records were modified since last refresh (for example with a "ModifiedDate" field on the database), you can convert CDS1 to a TRefreshClientDataset. Then fetch the modified records to another ClientDataSet (CDS2), and call the method "IncrementalRefresh" of CDS1 to merge the new records from CDS2 on CDS1.

Also, you can define a third Dataset (CDS3) with the deleted records, so they will be deleted from CDS1.

There is a little more info in the source code, but no sample provided. I just upload it here because it is very useful to me, and can be useful to you. Use it as you wish, and do whatever you want with the code. Just remember I give you no any kind of warranty, and that you are using it at your own risk.

If you have any suggestion/fix, please contact me

Regards,
Adrian.

   Latest Comments  View All Add New

Move mouse over comment to see the full text

Could not retrieve comments. Please try again later.

Server Response from: ETNACDC03