Options

The "Options" screen for a sequence is shown below:

The following properties are set on the Options screen:

Property:	Description:	Value:
Name	Name of the sequence.	<Text>
Description	Description of the sequence.	<Text>
Increment	The value by which the sequence value is increased for each next value call.	<Integer>
Min Value	The minimum value of the sequence object.	<Integer>
Max Value	The maximum value of the sequence object.	<Integer>
Datalength	The datalength of the sequence, either 9 or 18.	<9 \| 18>
Cycle	If set to Yes, the sequence will restart after reaching the last allowed value. Default is No, which will give an error after reaching the last allowed value of the sequence.	<No \| Yes>
DataType	The datatype of the sequence, either Numeric or Int.	<Numeric \| Int>
Last Number	The starting number for the sequence.	<Integer>

Remarks

In AMT sequences can be utilized by using the relevant SQL commands in a Free Join Query.
Refer to the documentation for your database management system to learn which syntax can be used.

MSSQL example:

FQ_INS_ORDER.PrepareExec ('INSERT INTO T_ORDERS (ORDERNR, CUSTID, ITEM) VALUES( NEXT VALUE FOR SQ_ORDERNR, @Param1, @Param2)')
FQ_INS_ORDER.SetParamNumeric ('@Param1', CUSTID)
FQ_INS_ORDER.SetParamAlpha ('@Param2', ITEM)
FQ_INS_ORDER.ExecPrepared ()

If getlastresult <> ''
SME(getlastresult)
endif