Hi John

>From what mentioned above, it may take quite long time to compare. Hereby, I would like to know, are there any better and effective way to do this?

Since this data is stored in a table to begin with, why not just use a single Read-Write Cursor to do this? All you need to do then is to SCAN the cursor and check GETFLDSTATE( -1 ) for each record.

That function will tell you if the record has been Deleted, Appended or Edited (actually it tells you if the status has been changed - you would still need to check to see what the current status is!).

This would be MUCH more efficient than trying to use collections I think.