Positions the record pointer on the closest matching record if a record search using FIND or SEEK is unsuccessful. With this setting, RECNO( ) returns the record number of the closest matching record, FOUND( ) returns false (.F.), and EOF( ) returns false (.F.).it is mistaken,
Positions the record pointer on the NEXT ORDERED record if a record search using FIND or SEEK is unsuccessful. With this setting, RECNO( ) returns the record number of the NEXT ORDERED record, FOUND( ) returns false (.F.), and EOF( ) returns false (.F.).
clear CREATE CURSOR neardata (f1 i) INSERT INTO neardata VALUES (7) INSERT INTO neardata VALUES (3) INSERT INTO neardata VALUES (10) INDEX ON f1 TAG t1 SET NEAR ON SEEK 8 ? f1,FOUND(),EOF() && the closest matching record it is f1=7 SEEK 9 ? f1,FOUND(),EOF() && the closest matching record it is f1=10 SEEK 9 ORDER t1 DESCENDING ? f1,FOUND(),EOF() && the closest matching record it is f1=10 SEEK 11 ? f1,FOUND(),EOF() && the closest matching record it is f1=10