In This Chapter
Servoy provides several ways in which a column may be automatically populated when a record is created. Some of the auto-enter options are also applicable when an existing record is updated.
Indicates that the value is deferred to the database at the time of insert. The value is populated and controlled by the database and it will not be overwritten from Servoy.
The UID parameter that was supplied at the time of login, entered at the time of record creation.
The UID parameter that was supplied at the time of login, reentered each time the record is modified.
The current date and time on the client, entered at the time of record creation.
The current date and time on the application server, entered at the time of record creation.
The current date and time on the client, reentered each time the record is modified.
The current date and time on the application server, reentered each time the record is modified.
A custom value is simply a literal value (i.e. 'Blue', 1.5) which may be used as a default. This option is only available for Integer, Number and Text data types.
This indicates that the value is deferred to the database at the time of insert. However, unlike Database-Managed system values, this value can be modified from Servoy after the record is inserted.
Lookup Values provide the option to auto-enter a value that is contextual to the record being inserted. Options include any of the record's data providers, any data providers from foundsets related to the record, as well as an global relations or variables.
Sequences may be used to auto-increment a column's value. This is ideal for populating primary key columns, which must be unique.
This is a sequence which is defined in the application tier and managed by Servoy. The sequence will generate integer values using a given next value and step value.
In deployment, Servoy Sequences are stored in the repository database and there are options to recalculate the sequence's next value from existing data.
Servoy will call a named sequence in the database to populate the value. The column will be populated and available prior to inserting the record
The sequential values are managed and populated by the database. The column is not populated until after the record is inserted
Servoy will automatically populate a text column with a textual representation of a UUID. Be sure that the column's UUID Flag is also enabled.