Number getSequenceType() Get the sequence type of the column. The sequence type is one of:
- JSColumn.NONE
- JSColumn.SERVOY_SEQUENCE
- JSColumn.DATABASE_SEQUENCE
- JSColumn.DATABASE_IDENTITY
- JSColumn.UUID_GENERATOR
However, in the Table Column editor, the Sequence option has only the following 4 choices
- JSColumn.NONE
- JSColumn.SERVOY_SEQUENCE
- JSColumn.DATABASE_IDENTITY
- JSColumn.UUID_GENERATOR
Considering the above, what is the JSColumn.DATABASE_SEQUENCE and how can one configure the column sequence to be like that?
I am having an issue with columns which are configured as Identity columns in the database and are of type Integer. Servoy by default maps those as using a sequence type of JSColumn.DATABASE_IDENTITY but when a new record in the table is created and is not saved yet, the value of that column is something like DbIdentValue15485912 - clearly that value is not an integer. When the record is saved in the database it retrieves the correct value which the database has generated, however for that intermediate step while the record is not saved yet, the value of the integer column is not an integer and it is causing us some issues with certain validations/calculations/etc.