# 355 Locate Not Indicating that Record Exists When it is Present in Data File

---

I have a wwDBSISAMtable with 1 primary key field, 20 other fields and, starts out at say, 2000 records. The table is attached to a wwDBGRID, and I need the ability to sort the grid on any of the fields, so all 20 fields are indexed. Periodically, I add 100 to 1000 records to the table. Some of these additions are new, in the sense that they have primary keys which don't already exist in the table, and others are 'updates' to existing records in the table. I am currently iterating through the new records, doing a locate on the existing table, and then adding or editing/posting as appropriate. I have found that sometimes Locate does not return a result, but DBISAM gives me a primary key violation error when I try to insert/post the record.