SET SEQUENCENUMBER

Controls the way Automatic Sequence Numbers operate.

SET SEQUENCENUMBER {object | ALL} {number | variable | ON | OFF}.

where

object	The name of an Entity-Set Relationship with fields that contains an ASN defined
ALL	Refer to all Entity-Sets and Relationships with fields that contain ASNs defined
number	a positive number from 1 up to 15-digit number
variable	a variable containing a positive number from 1 up to a 15-digit number. If the contents of the variable is $null, the number is assumed to be 1.

The command sets an initial number, enables or disables automatic sequential numbers to the mentioned object or to ALL the objects that contain ASN.

Examples

SET SEQUENCENUMBER ALL 1

Resets all existing ASN to 1.

LET MyVar = 1000
SET SEQUENCENUMBER Customer MyVar

Initializes the ASN for Customer to the value of 1000.

SET SEQUENCENUMBER ALL OFF

Disables all ASN.

SET SEQUENCENUMBER Customer ON

Enables the ASN for the Customer object and $ZimSeqNum returns the current sequence number available for Customer

19 junho 2020

Updated12 junho 2022

ByJason Lee

Was this article helpful?