Difference between revisions of "DatabaseRecord.CurrencyColumn"

From Xojo Documentation

 
Line 1: Line 1:
 +
{{Deprecated|version=2019r2|replacement=[[DatabaseRow.CurrencyColumn]]}}
 
{{MethodBox
 
{{MethodBox
 
| name=CurrencyColumn
 
| name=CurrencyColumn

Latest revision as of 13:46, 11 July 2019

Method

DatabaseRecord.CurrencyColumn(Name As String) As Currency

Supported for all project types and targets.

Gets the Currency value for the column Name.


Method

DatabaseRecord.CurrencyColumn(Name As String, Assigns value As Currency)

Supported for all project types and targets.

Sets the Currency value for the column Name.

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"
row.CurrencyColumn("AverageTicketPrice") = 15.50

myDB.InsertRecord("Team", row)

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