Difference between revisions of "SET SEQNO"
From Lianjapedia
Helen.george (Talk | contribs) |
|||
| 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== | ||
| Line 15: | Line 12: | ||
The SET SEQNO command and CURRSEQNO() and SEQNO() functions are only supported for Lianja tables. | 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== | ||
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
