General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Can someone shed some light here?
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.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only