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.