Reported By: Jackson Gomes Reported On: 1/31/2001 For: Version 2.06 Build 1
# 716Using Locate Method on Query Result Sets Returns Random Results I have a query as follows. The key fields are APP_KEY, FORM_NAME When I use the locate command as below it does not work as expected, returning false.
NOTE: The value I'm searching is in the table.
SELECT FORM_NAME, FORM_ID, FORM_CAPTION, APP_KEY
FROM UCS_FORMS
Where APP_KEY = :APP_KEY
{ Locate command }
if Users.qryForms.Locate('FORM_NAME',FormName,[]) then
ResolutionFixed Problem on 2/1/2001 in version 2.07 build 1