The best method to find a record using an integer value
pcerdaz
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
pcerdaz
May be there is some index or filter that affect the Locate method.
Any help would be gratefully.
Regards,
pcerdaz
"pcerdaz" <pce...@manquehue.net> escribió en el mensaje news:...
Jeff Overcash (TeamB)
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.
--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
And so I patrol in the valley of the shadow of the tricolor
I must fear evil. For I am but mortal and mortals can only die.
Asking questions, pleading answers from the nameless
faceless watchers that stalk the carpeted corridors of Whitehall.
(Fish)