Difference between revisions of "SET SOFTSEEK"
From Lianjapedia
Yvonne.milne (Talk | contribs) m (1 revision) |
Yvonne.milne (Talk | contribs) |
||
(3 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Sets soft seeking of data | Sets soft seeking of data | ||
− | |||
==Syntax== | ==Syntax== | ||
SET SOFTSEEK ON | OFF | (<expL>) | SET SOFTSEEK ON | OFF | (<expL>) | ||
− | |||
==See Also== | ==See Also== | ||
− | + | [[INDEX]], [[SEEK]], [[SET NEAR]] | |
− | + | ||
==Description== | ==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. | 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== | ==Example== | ||
Line 35: | Line 31: | ||
</code> | </code> | ||
− | |||
− | |||
− | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Commands]] | [[Category:Commands]] | ||
[[Category:Set_Commands|SOFTSEEK]] | [[Category:Set_Commands|SOFTSEEK]] | ||
− | [[Category: | + | [[Category:NoSQL Commands]] |
− | + |
Latest revision as of 12:48, 4 February 2013
Contents
Purpose
Sets soft seeking of data
Syntax
SET SOFTSEEK ON | OFF | (<expL>)
See Also
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.