Record.Insert Method

Inserts a record into a table.

Syntax

[Ok := ]  Record.Insert(RunTrigger: Boolean, InsertWithSystemId: Boolean)

Parameters

Record
 Type: Record
An instance of the Record data type.

RunTrigger
 Type: Boolean
If this parameter is true, the code in the OnInsert Trigger is executed. If this parameter is false, the code in the OnInsert trigger is not executed. The default value is false.

InsertWithSystemId
 Type: Boolean
If this parameter is true, the SystemId field of the record is given a value that you explicitly assign. If a value is not assigned, then the platform assigns one. If this parameter is false, the SystemId field is given a value that is auto-generated by the platform. The default value is false.

Return Value

Ok
 Type: Boolean
true if the operation was successful; otherwise false. If you omit this optional return value and the operation does not execute successfully, a runtime error will occur.

Remarks

The inserted record will automatically get assigned a SystemId by the platform. To assign a specific SystemId instead of the one assigned by the platform, use Insert(Boolean, Boolean) instead.

Example

This example shows how to use the INSERT method to insert a record with a specified SystemId.

var
    CustomerRec: Record Customer;
    Text000: Label 'Customer no: %1 inserted.';
    Text001: Label 'Customer no: %1 already exists.';
begin
    CustomerRec.Init(); 
    CustomerRec."No." := '1120'; 
    CustomerRec.SystemId := '{B6666666-F5A2-E911-8180-001DD8B7338E}';  
    if CustomerRec.INSERT(true, true) then  
      Message(Text000, CustomerRec."No.")  
    else  
      Message(Text001, CustomerRec."No.");
end;

No run-time error occurs if customer 1120 already exists.

See Also

SystemId Field
Record Data Type
Getting Started with AL
Developing Extensions