DatabaseRecord.DateColumn

From Xojo Documentation

Revision as of 22:02, 5 September 2019 by Gperlman (talk | contribs)
Method

DatabaseRecord.DateColumn(Name As String) As Date

Supported for all project types and targets.

Gets the Date value for the column Name.


Method

DatabaseRecord.DateColumn(Name As String, Assigns value As Date)

Supported for all project types and targets.

Sets the Date value for the column Name.

Sample Code

Creates a new row in the team table:

Dim row As New DatabaseRecord

Dim openingDay As New Date
openingDay.Day = 4
openingDay.Month = 4
openingDay.Year = 2013

row.Column("Name") = "Penguins"
row.Column("Coach") = "Bob Roberts"
row.Column("City") = "Boston"
row.DateColumn("OpeningDay") = openingDay

myDB.InsertRecord("Team", row)

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