Re: Removing dublicate records in table and hostarray

Hi Graham,

> This is where some of us are having a problem. Why don't you want to
> read only the records which are not duplicates? It will not be a
> problem.

Your approach sounds interesting. I will try experimenting with it.

> At the and of the cursor you will have inserted (and removed, marked
> or otherwise) all the non-duplicates.
> What is left in the transaction table is the ones which already
> existed in the master table. Do with these what you will.

Yes, but those cannot be deleted from rowid.. Thats the only catch i have found so far ;-)

Thanks Graham!

Brian

Brian Rasmusson, Software engineer & analyst        e-mail: br_at_belle.dk
Belle Systems A/S                                   web   : www.belle.dk
Network, Internet and communication specialists     phone : +45 59442500
------------------------------------------------------------------------