Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
SET NEAR Command
Collapse the table of content
Expand the table of content

SET NEAR Command

Visual Studio .NET 2003

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

Show:
© 2015 Microsoft