Message
From
30/07/2003 09:01:33
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Problem with Seek() function
Miscellaneous
Thread ID:
00814877
Message ID:
00814877
Views:
45
I have a table indexed on an integer field in the "Key" tag with these values:
702065
702066
702067
702068
702069
etc....
The record with the value 702066 in deleted and i Set Deleted On in my program.
If i write (also in Command Window)
Messagebox(Seek(702066,"MyTable","Key"))
It returns the .F. value but the record pointer is not positioned to the end of MyTable (Eof), but on the record after that deleted with the value i searched (702067).
In the fox Guide i read:
"If a match is found, SEEK( ) returns true (.T.), and the record pointer moves to the matching record. If no match is found, SEEK( ) returns false (.F.) and the record pointer moves to the end of the file."
I have no settings on SET NEAR and the default value must be "OFF"
Where is the error.
702065
702066
702067
702068
702069
etc....
The record with the value 702066 in deleted and i Set Deleted On in my program.
If i write (also in Command Window)
Messagebox(Seek(702066,"MyTable","Key"))
It returns the .F. value but the record pointer is not positioned to the end of MyTable (Eof), but on the record after that deleted with the value i searched (702067).
In the fox Guide i read:
"If a match is found, SEEK( ) returns true (.T.), and the record pointer moves to the matching record. If no match is found, SEEK( ) returns false (.F.) and the record pointer moves to the end of the file."
I have no settings on SET NEAR and the default value must be "OFF"
Where is the error.