>Hi...
>Why "LOCATE" doesn't always work?
>For testing purposes,I'm working at the command window level. I SELECT table B.
>I write: "LOCATE FOR IDSTUDENT = 15" (IDSTUDENT being an integer value) and the pointer goes to the end of the file, meaning it didn't find a record, even though I'm positive it exists.
>If I write: "LOCATE FOR STSTATUS='ACTIVE'" (STSTAUS being a string value) and the pointer is located in the first "ACTIVE" record.
>Then I SELECT table A, and both the above commands get the expected results.
>I am positive that the values I'm looking for exist.
>Anyone has a hint?
>Thanks in advance.
>Ulises.
LOCATE works only on the table/cursor/view open in the CURRENT work area.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up