Xojo Documentation Xojo Documentation

Property (As Currency )

aDatabaseColumn.CurrencyValue = newCurrencyValue
or
CurrencyValue = aDatabaseColumn.CurrencyValue

New in 2019r2

Supported for all project types and targets.

Used to get and set the values of Currency field types.

Notes

For situations where you need to set a database column to NULL, you should use the Value property like this:

rs.EditRow
rs.Column("MyCurrencyColumn").Value = Nil // sets to NULL in the database
rs.SaveRow

Sample Code

Get the currency value of a column in a RowSet:

// rs is a RowSet with a currency column called "Amount"
Var amount As Currency
amount = rs.Column("Amount").CurrencyValue

Set the currency value of a column in a RowSet:

// rs is a RowSet with a currency column called "Amount":
rs.EditRow
rs.Column("Amount").CurrencyValue = 123.45
rs.SaveRow