Difference between revisions of "Database.InsertRecord"

From Xojo Documentation

Line 1: Line 1:
 +
{{Deprecated|version=2019r2|replacement=[[Database.InsertRow]]}}
 
{{MethodBox
 
{{MethodBox
 
| name=InsertRecord
 
| name=InsertRecord

Revision as of 21:31, 20 May 2019

Method

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.

Notes

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