Xojo Documentation Xojo Documentation

Property (As Double )

aDatabaseField.DoubleValue = newDoubleValue
or
DoubleValue = aDatabaseField.DoubleValue

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.Edit
rs.Field("MyDoubleColumn").Value = Nil // sets to NULL in the database
rs.Update

Sample Code

Get the double value of a column in a RecordSet:

// rs is a RecordSet with a double column called "InterestRate"
Dim interestRate As Double
interestRate = rs.Field("InterestRate").DoubleValue

Set the double value of a column in a RecordSet:

// rs is a RecordSet with a double column called "InterestRate":
rs.Edit
rs.Field("InterestRate").DoubleValue = 3.625
rs.Update