Add record to DataTable externally

[DavidSkilbeck]

Hi,

from the schema for CDBObject I see the below.

AddRecord Add Row Adds a new record to a data table. Control [retval] Record (Long) : Record ID of the new record in the data table.

The below code works. However, I thought I would be able to use - obj.Interface.AddRecord(RecordId); to return the record id of the new record.

But, it does not allow me. Unless I am going about the syntax wrong? Thanks,

obj.Interface.AddRecord();
RecordId = obj.Interface.RecordCount(RecordId);
RecordId = RecordId - 1;
obj.Interface.SetValue("TestField", RecordId, "Test");

[AndrewScott · Accepted solution]

The correct syntax is:

RecordId = obj.Interface.AddRecord();
obj.Interface.SetValue("TestField", RecordId, "Test");

The record ID is returned by the AddRecord() method.