Weeding out a Corrupt Record. Input requested...

[Jim Randell]

Hello All,

Looking for input on strange corruption issue.

The scenario:

Table A has an un-editable record that displays “?” in each field. This record breaks certain scripts.

I assume the record is corrupt.

The procedure I followed was:

1 copy file

2 Open copy and delete all records from table A

3 save copy as compacted, delete first copy

4 open original file, go to table A, find all records, omit the corrupt one.

5 export good records (did this twice, once as csv, other as fm file) and verified corrupt record did not export

6 Imported records into compacted copy (which has zero records in it).

The corrupt record magically returns after import, whether I use csv or FM file.

I have several ideas and variations to try to fix, but first, thought I would run this by you guys, to see if anyone has any suggestions.

Thanks for any input,

-JR