Xojo Documentation Xojo Documentation

Method

DatabaseRecord.FieldCount() As Integer

Supported for all project types and targets.

Returns the number of fields in the DatabaseRecord.

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"

myDB.InsertRecord("Team", row)

If myDB.Error Then
MsgBox("DB Error: " + myDB.ErrorMessage)
Else
MsgBox("Fields added: " + Str(row.FieldCount)
End If