DatabaseRecord.FieldName

From Xojo Documentation

You are currently browsing the old Xojo documentation site. Please visit the new Xojo documentation site!
Method

DatabaseRecord.FieldName(idx As Integer) As String

Supported for all project types and targets.

Returns the name of the field in the DatabaseRecord specified by idx. The fields are in a 0-based array.

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("Field 2 Name: " + row.FieldName(1))
End If