Xojo Documentation Xojo Documentation

Method

DatabaseRecord.IntegerColumn(Name As String) As Integer

Supported for all project types and targets.

Gets the Integer value for the column Name.

Method

DatabaseRecord.IntegerColumn(Name As String, Assigns value As Integer)

Supported for all project types and targets.

Sets the Integer value for the column Name.

Sample Code

Creates a new row in the team table:

Dim row As New DatabaseRecord

row.Column("Name") = "Penguins"
row.Column("Coach") = "Bob Roberts"
row.Column("City") = "Boston"
row.IntegerColumn("AverageAttendance") = 6532

myDB.InsertRecord("Team", row)

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