DatabaseColumn.IntegerValue

From Xojo Documentation

Revision as of 20:01, 10 July 2019 by Gperlman (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
You are currently browsing the old Xojo documentation site. Please visit the new Xojo documentation site!

Property (As Integer )
aDatabaseColumn.IntegerValue = newIntegerValue
or
IntegerValue = aDatabaseColumn.IntegerValue

New in 2019r2

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.EditRow
rs.Column("MyIntegerColumn").Value = Nil // sets to NULL in the database
rs.SaveRow

Sample Code

Get the integer value of a column in a RowSet:

// rs is a RowSet with an integer column called "Quantity"
Var quantity As Integer
quantity = rs.Column("Quantity").IntegerValue

Set the integer value of a column in a RowSet:

// rs is a RowSet with an integer column called "Quantity":
rs.EditRow
rs.Column("Quantity").IntegerValue = 3
rs.SaveRow