Difference between revisions of "SET NEAR"

From Recital Documentation Wiki
Jump to: navigation, search
 
(Products)
 
(6 intermediate revisions by 2 users not shown)
Line 1: Line 1:
=SET NEAR=
 
 
 
==Class==
 
Indexing
 
 
 
 
==Purpose==
 
==Purpose==
 
Sets ’soft’ seeking of data
 
Sets ’soft’ seeking of data
Line 15: Line 8:
  
 
==See Also==
 
==See Also==
SET SOFTSEEK, SEEK, FIND, INDEX, SOUNDEX()
+
[[FIND]], [[INDEX]], [[SEEK]], [[SET SOFTSEEK]], [[SOUNDEX()]]
  
  
Line 23: Line 16:
  
 
==Example==
 
==Example==
<pre>
+
<code lang="recital">
 
set near on
 
set near on
 
use demo
 
use demo
Line 39: Line 32:
 
.F.
 
.F.
 
? eof()
 
? eof()
.T.</pre>
+
.T.</code>
  
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital Server, Recital  
 +
[[Category:Documentation]]
 +
[[Category:Commands]]
 +
[[Category:Set_Commands|NEAR]]
 +
[[Category:Indexing]]
 +
[[Category:Indexing Set Commands]]

Latest revision as of 16:28, 23 November 2009

Purpose

Sets ’soft’ seeking of data


Syntax

SET NEAR ON | OFF | (<expL>)


See Also

FIND, INDEX, SEEK, SET SOFTSEEK, SOUNDEX()


Description

When SET NEAR is ON, searches of the table go to the record immediately following the potential location of the search key in the relevant file, if the key itself is not found. SET NEAR is synonymous with SET SOFTSEEK. Both SET NEAR and SET SOFTSEEK function when any valid expression is used with the SEEK command. It has no effect on relationships. By default, NEAR is OFF.


Example

set near on
use demo
select state
seek "MB"
? found()
.F.
? eof()
.F.
? state
MD
set near off
seek "MB"
? found()
.F.
? eof()
.T.


Products

Recital Server, Recital