From Xojo Documentation


Database.InsertRecord(TableName as String,Data as DatabaseRecord)

Supported for all project types and targets.

Inserts Data (a populated DatabaseRecord) as a new row in TableName.


Always check the Error property to verity that the data was added.

Sample Code

This code adds a row to an existing Team table with the columns "Name", "Coach" and "City":

Dim row As New DatabaseRecord
// ID will be updated automatically
row.Column("Name") = "Penguins"
row.Column("Coach") = "Bob Roberts"
row.Column("City") = "Boston"

App.DB.InsertRecord("Team", row)

If App.DB.Error Then
MsgBox("DB Error: " + App.DB.ErrorMessage)
End If