Difference between revisions of "SET SEQNO"
From Lianjapedia
Helen.george (Talk | contribs) |
|||
(3 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Reset sequence numbering to specified number | Reset sequence numbering to specified number | ||
− | |||
==Syntax== | ==Syntax== | ||
SET SEQNO TO <expN> | SET SEQNO TO <expN> | ||
− | |||
==See Also== | ==See Also== | ||
[[CURRSEQNO()]], [[SEQNO()]], [[ZAP]] | [[CURRSEQNO()]], [[SEQNO()]], [[ZAP]] | ||
− | |||
==Description== | ==Description== | ||
The SET SEQNO TO <expN> command resets the sequence number of the currently active table to the specified <expN> value. The next time the SEQNO() function is called, the value returned will be <expN> + 1. The ZAP command will reset the sequence number to 0. The next time the SEQNO() function is called, the value returned will be 1. | The SET SEQNO TO <expN> command resets the sequence number of the currently active table to the specified <expN> value. The next time the SEQNO() function is called, the value returned will be <expN> + 1. The ZAP command will reset the sequence number to 0. The next time the SEQNO() function is called, the value returned will be 1. | ||
− | The SET SEQNO command and CURRSEQNO() and SEQNO() functions are only supported for | + | The SET SEQNO command and CURRSEQNO() and SEQNO() functions are only supported for Lianja tables. |
− | + | ||
==Example== | ==Example== | ||
Line 23: | Line 19: | ||
edit | edit | ||
</code> | </code> | ||
− | |||
==Products== | ==Products== | ||
− | + | Lianja Server, Lianja | |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Commands]] | [[Category:Commands]] | ||
[[Category:Set_Commands|SEQNO]] | [[Category:Set_Commands|SEQNO]] | ||
+ | [[Category:Lianja VFP Extensions]] | ||
+ | [[Category:VFP Command Extensions]] |
Latest revision as of 12:23, 12 December 2012
Purpose
Reset sequence numbering to specified number
Syntax
SET SEQNO TO <expN>
See Also
Description
The SET SEQNO TO <expN> command resets the sequence number of the currently active table to the specified <expN> value. The next time the SEQNO() function is called, the value returned will be <expN> + 1. The ZAP command will reset the sequence number to 0. The next time the SEQNO() function is called, the value returned will be 1.
The SET SEQNO command and CURRSEQNO() and SEQNO() functions are only supported for Lianja tables.
Example
use demo set seqno to 2000 edit
Products
Lianja Server, Lianja