Difference between revisions of "SET SOFTSEEK"

From Recital Documentation Wiki
Jump to: navigation, search
Line 1: Line 1:
=SET SOFTSEEK=
 
 
 
 
==Class==
 
==Class==
 
Indexing
 
Indexing
Line 15: Line 12:
  
 
==See Also==
 
==See Also==
[[SET NEAR]]
+
[[FIND]], [[INDEX]], [[SEEK]], [[SET NEAR]]
  
  
Line 39: Line 36:
 
.F.
 
.F.
 
? eof()
 
? eof()
.T.</code>
+
.T.
 +
</code>
  
  

Revision as of 11:28, 20 April 2009

Class

Indexing


Purpose

Sets soft seeking of data


Syntax

SET SOFTSEEK ON | OFF | (<expL>)


See Also

FIND, INDEX, SEEK, SET NEAR


Description

When SET SOFTSEEK 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 SOFTSEEK is synonymous with SET NEAR. 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, SOFTSEEK is OFF.


Example

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


Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer