Date: Thu, 28 Mar 2024 14:14:35 +0000 (UTC) Message-ID: <1342411316.10669.1711635275992@911f0a1bad02> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_10668_1814708183.1711635275991" ------=_Part_10668_1814708183.1711635275991 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
Servoy provides several ways in which a column may be automatically popu= lated when a record is created. Some of the auto-enter options are also app= licable when an existing record is updated.
Indicates that the value is deferred to the database at the time of inse= rt. The value is populated and controlled by the database and it will not b= e overwritten from Servoy.
The UID parameter that was supplied at the time of login, entered at the time of rec= ord creation.
The UID parameter that was supplied at the time of login, reentered each time the re= cord is modified.
The current date and time on the client, entered at the time of record c= reation.
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 re= cord 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 contextua= l to the record being inserted. Options include any of the record's data pr= oviders, any data providers from foundsets related to the record, as well a= s 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.
i.e a step value of 1 will yield sequential values of 1,2,3,4...
A step value of 2 will yield 1,3,5,7...
=20In deployment, Servoy Sequences are stored in the repository database an= d 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= p>
The sequential values are managed and= populated by the database. The column is not populated until after the rec= ord is inserted
Servoy will automatically populate a text column with a textual represen= tation of a UUID. Be sure that the column's UUID Flag is also enabled.