Record.Init() Method
Version: Available or changed with runtime version 1.0.
Initializes a record in a table.
Syntax
Record.Init()
Parameters
Record
Type: Record
An instance of the Record data type.
Remarks
This method assigns default values to each field in the record, including the SystemId field when a table is created. For any new field added later into the record, values are initialized by default or by using InitValue Property (Record). If no value was assigned when the table was created, the values are assigned based on the data type, as shown in the following table.
| Data type | Default value |
|---|---|
| BigInteger | 0 |
| BigText | <Empty> |
| BLOB | <Empty> |
| Boolean | No |
| Code | '' (empty string) |
| Date | 0d (Undefined date) |
| DateFormula | '' (empty string) |
| DateTime | 0DT (Undefined datetime) |
| Decimal | 0.0 |
| Duration | 0 |
| GUID | 00000000-0000-0000-0000-000000000000 |
| Integer | 0 |
| Option | 0 |
| RecordID | <Empty> |
| TableFilter | <Empty> |
| Text | '' (empty string) |
| Time | 0T (Undefined time) |
Note
Primary key and timestamp fields are not initialized.
After the method runs, you can change the values in any or all of the fields before you call the Insert Method (RecordRef) to enter the record in the table. Be sure that the fields that make up the primary key contain values that make the total primary key unique. If the primary key isn't unique (such as the record already exists), then the record is rejected.
The method works in the same way as the Init Method (RecordRef).
Note
You aren't required to call the Init() method every time you intend to insert a record as, the fields are already populated, either with default values or the values set by the InitValue property. For the use cases, where the values need to be refreshed with each iteration in a loop or if they are inserted through a parameter, you should use the Init() method to make sure that the record aligns with the other data in the table.