The best method to find a record using an integer value

[pcerdaz]

... I'm sorry, accidentally I did a click on Enter key ...
May be there is some index or filter that affect the Locate method.
Any help would be gratefully.

Regards,
pcerdaz

Hello,
Which is the best method to find a record using a field with integer
values?
Actually I'm using Locate, but there is something that fails because
sometimes it does not found the last record inserted; this occur after I
did a commit retaining and also a close and then a open method for the
table where I'm searching for.
May be some index or

[Jeff Overcash (TeamB)]

Post by pcerdaz
... I'm sorry, accidentally I did a click on Enter key ...
May be there is some index or filter that affect the Locate method.
Any help would be gratefully.
Regards,
pcerdaz

Hello,
Which is the best method to find a record using a field with integer
values?
Actually I'm using Locate, but there is something that fails because
sometimes it does not found the last record inserted; this occur after I
did a commit retaining and also a close and then a open method for the
table where I'm searching for.
May be some index or

Locate works on the local data, it does not do anything on the sever side. So
you will have to close and reopen the query to get the current data. Also make
sure the transaction the dataset you are trying to read from is not a snapshot
transaction or else your commit retaining will have no affect for your query.