DatabaseRecord.Column

From Xojo Documentation

Revision as of 19:07, 3 September 2020 by THill (talk | contribs) (Text replacement - "{{DeprecatedItemItem|" to "{{DeprecatedItem|")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Method

DatabaseRecord.Column(Name As String) As String

Supported for all project types and targets.

Gets the String value for the column Name.


Method

DatabaseRecord.Column(Name As String, Assigns value As String)

Supported for all project types and targets.

Sets the String value for the column Name.


Method

DatabaseRecord.Column(Index As Integer) As String

Supported for all project types and targets.

Gets the String value for the column at position Index. The first index is 1.

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)
End If