Hi, I'm using some components to import information from a text file into a TPgTable component. When this record finds a matching record based on an index condition it updates the record else it inserts it. Now the underlying table has a unique constraint so when there is an attempt to insert a duplicate record there is an error. However this should not happen because it should locate the record and update it. By using provided methods I've manually done a Locate using the supplied values and occassionally it returns False even though I know a record having a key with that value exists.
What would cause Locate to fail occasionally?