SET SEQUENCENUMBER

Controls the way Automatic Sequence Numbers operate.

Syntax

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.

Comments

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