DatabaseField.Int64Value
From Xojo Documentation
This item was deprecated in version 2019r2. Please use DatabaseColumn.Int64Value as a replacement. |
Property (As Int64 )
aDatabaseField.Int64Value = newInt64Value
or
Int64Value = aDatabaseField.Int64Value
Supported for all project types and targets.
or
Int64Value = aDatabaseField.Int64Value
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.Edit()
rs.Field("MyColumn").Value = Nil // sets to NULL in the database
rs.Update()
rs.Field("MyColumn").Value = Nil // sets to NULL in the database
rs.Update()
Sample Code
Get the Int64 value of a column in a RecordSet:
Set the Int64 value of a column in a RecordSet:
// rs is a RecordSet with a Int64 column called "ID":
rs.Edit
rs.Field("ID").Int64Value = 456789
rs.Update
rs.Edit
rs.Field("ID").Int64Value = 456789
rs.Update