Xojo Documentation Xojo Documentation

Property (As Double )

aDatabaseColumn.DoubleValue = newDoubleValue
or
DoubleValue = aDatabaseColumn.DoubleValue

New in 2019r2

Supported for all project types and targets.

Used to get and set the values of Double 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("MyDoubleColumn").Value = Nil // sets to NULL in the database
rs.SaveRow

Sample Code

Get the double value of a column in a RowSet:

// rs is a RowSet with a double column called "InterestRate"
Var interestRate As Double
interestRate = rs.Column("InterestRate").DoubleValue

Set the double value of a column in a RowSet:

// rs is a RowSet with a double column called "InterestRate":
rs.EditRow
rs.Column("InterestRate").DoubleValue = 3.625
rs.SaveRow