Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Determines where the record pointer is positioned after FIND or SEEK unsuccessfully searches for a record.
SET NEAR ON | OFF
Parameters
- ON
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.). - OFF
(Default) Positions the record pointer at the end of the table if a record search using FIND or SEEK is unsuccessful. With this setting, RECNO( ) returns the number of records in the table plus 1, FOUND( ) returns false (.F.), and EOF( ) returns true (.T.).
Remarks
A search is unsuccessful when no record meets the search criteria.
Issuing RECNO( ) with an argument of 0 returns the record number of the closest matching record if a search is unsuccessful, regardless of the setting of SET NEAR.
SET NEAR is scoped to the current data session.
See Also
EOF( ) | FIND | FOUND( ) | RECNO( ) | SEEK | SET DATASESSION