Subject | Int64 parameter in SELECT is not being set properly |
---|---|
Author | Chuck Belanger |
Post date | 2018-08-11T06:03:30Z |
Hello:
I am using a TIB_Cursor SELECT and using parameters to set an Int64:
ParambyName('cpuid').AsInt64 := CPUID (201916632774063);
This apparently calls IB_Components.TIB_column.SetasInt64
then: IB_Components.TIB_ColumnInteger.SetAsString
Which leads to SysUtils StrToInt
so that I get an error on setting the parameter asInt64,
"'201916632774063' is not a valid integer'
Of course it is not! But what is going on here to convert the Int64 to a
string and then back erroneously to an integer.
What can I do to make the parameter assignment work as expected?
Thank you,
Chuck
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
I am using a TIB_Cursor SELECT and using parameters to set an Int64:
ParambyName('cpuid').AsInt64 := CPUID (201916632774063);
This apparently calls IB_Components.TIB_column.SetasInt64
then: IB_Components.TIB_ColumnInteger.SetAsString
Which leads to SysUtils StrToInt
so that I get an error on setting the parameter asInt64,
"'201916632774063' is not a valid integer'
Of course it is not! But what is going on here to convert the Int64 to a
string and then back erroneously to an integer.
What can I do to make the parameter assignment work as expected?
Thank you,
Chuck
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus