Xojo Documentation Xojo Documentation

Property (As Int64 )

aDatabaseColumn.Int64Value = newInt64Value
or
Int64Value = aDatabaseColumn.Int64Value

New in 2019r2

Supported for all project types and targets.

Used to get and set the values of Int64 field types.

Notes

Support for 64-bit integers is at the framework level. Database plug-ins need to be updated to support 64-bit integers.

For situations where you need to set a database column to NULL, you should use the Value property like this:

rs.EditRow
rs.Column("MyColumn").Value = Nil // sets to NULL in the database
rs.SaveRow

Sample Code

Get the Int64 value of a column in a RowSet:

// rs is a RowSet with a Int64 column called "ID"
Var id As Int64
id = rs.Column("ID").Int64Value

Set the Int64 value of a column in a RowSet:

// rs is a RowSet with a Int64 column called "ID":
rs.EditRow
rs.Column("ID").Int64Value = 456789
rs.SaveRow