Hi All,

This morning I noticed something wierd in 1 of our tables in the database. 2 of the 139000 + records had 2 values in 1 of the fields. I had opened up the table in VFP to look at what had caused an update error. Error said uniqueness of that field had been violated. When I set the pointer to the record, the field indicated a value of 0. If I set the pointer to an other record the field showed it's correct value of 138517. This is a numeric field N(11). There was also a strange character at the begining of the field. A vertical black line.

This field 'hr_no' is the primary index field of the table. During the night there is a robot program that will pack this & other tables. When this program tried to pack this table, the error occured. This is why I decided to look at the table. The index for this field was no longer there. The other indexes were there though.

The tables are all DBFs in a standard DBC database. All our programs exept the robots access the database through the FoxPro ODBC driver. This is the second time we have noticed this problem in the 3 months that this system has been in place. Could this be an update error due to a limitation in the Foxpro ODBC driver. There is 1 program that does an update on anywhere from 100 - 300 records at a time using a TABLEUPDATE(). Judging by the timestamp of the records in question only this program could have been used to update the table.

Help Please. I have no idea what is happening.
TIA
Mike