Difference between revisions of "SET SOFTSEEK"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| Line 15: | Line 15: | ||
==See Also== | ==See Also== | ||
| − | SET NEAR | + | [[SET NEAR[[ |
| Line 23: | Line 23: | ||
==Example== | ==Example== | ||
| − | < | + | <code lang="recital"> |
set softseek on | set softseek on | ||
use demo | use demo | ||
| Line 39: | Line 39: | ||
.F. | .F. | ||
? eof() | ? eof() | ||
| − | .T.</ | + | .T.</code> |
==Products== | ==Products== | ||
Recital Database Server, Recital Mirage Server, Recital Terminal Developer | Recital Database Server, Recital Mirage Server, Recital Terminal Developer | ||
| + | [[Category:Documentation]] | ||
| + | [[Category:Commands]] | ||
| + | [[Category:Set_Commands|NEAR]] | ||
Revision as of 12:06, 12 March 2009
Contents
SET SOFTSEEK
Class
Indexing
Purpose
Sets soft seeking of data
Syntax
SET SOFTSEEK ON | OFF | (<expL>)
See Also
[[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
