Daniel,
Can you do the operation from VFP itself?
Are you sure that you don't have data corruption in that column?
Why not simply run a SQL SELECT from the source to the destination to get the unique rows?
>I have an stand alone table size=1.6GB, fields=54. I created a com dll to:
>- delete all indexes
>- create an index by 1 field unique
>- set order to the tag created above
>- and copy the table to another directory
>
>I pass to the procedure the from tablename and the to tablename.
>When I call this procedure with an small table (300K) it works fine. When I executed with the table of 1.6GB I get this error:
>-1073741819
>
>My computer is an Athlon 1.8 with 1GB of ram. I have over 30GB of free space in my HD. Any ideas on how to fix this?