General information
Title:
How'd I get 2 values in 1 field?
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only