When "FindFirst" does not work ?
Posted on 1999-01-05
I've got a database that is beeing aotomatically updated from DOS-files. In the database there are relations (one-many). On inserting a new record on the many-side I check wether the corresponding one-side-record exists.
In too many cases, the "FindFirst" cant find the record.
The one-side-table is opened as dynaset, the primary (unique) key is defined composed of more fields which match with the argument in the "FindFirst". The one-side record is, in many cases inserted a previous day, so there could not be a refresh-problem. Is there something to do about it?