DatabaseField.IntegerValue

From Xojo Documentation

Revision as of 21:23, 23 January 2019 by PLefebvre (talk | contribs)

(diff) ← Older revision | Approved revision (diff) | Latest revision (diff) | Newer revision → (diff)
Property (As Integer )
aDatabaseField.IntegerValue = newIntegerValue
or
IntegerValue = aDatabaseField.IntegerValue

Supported for all project types and targets.

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

Sample Code

Get the integer value of a column in a RecordSet:

// rs is a RecordSet with an integer column called "Quantity"
Dim quantity As Integer
quantity = rs.Field("Quantity").IntegerValue

Set the integer value of a column in a RecordSet:

// rs is a RecordSet with an integer column called "Quantity":
rs.Edit
rs.Field("Quantity").IntegerValue = 3
rs.Update