DatabaseRecord.FieldCount

From Xojo Documentation

Revision as of 13:36, 11 July 2019 by Gperlman (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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