DatabaseColumn.IntegerValue
From Xojo Documentation
Property (As Integer )
aDatabaseColumn.IntegerValue = newIntegerValue
or
IntegerValue = aDatabaseColumn.IntegerValue
New in 2019r2
Supported for all project types and targets.
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
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
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
rs.EditRow
rs.Column("Quantity").IntegerValue = 3
rs.SaveRow