Hi Robert,

Unrelated observation: is English word "transfer" translates into "transfert" in French? Because it's the second time I'm correcting it in the thread title for you...

>i made a transfert from table A table B
>
>
>the table structure are identical
>
>there is a methode to compare the data to see if there are the same ???
>
>thank you

As for the data comparision there are several ideas.

Assuming the structures are identical:

select * from myOldTable ;
union ;
select * from myNewTable
into cursor curEverything nofilter

If the curEverything has the same number of records as myOldTable, then both tables have exactly same records. Otherwise you may find difference.