FCL-DB QWord not supp?
lazarus / 16-Databases

----------------------------------------------------------------------
hinst · 2014-08-07 14:26

for fields we have AsInteger: Integer and AsBigInt: Int64; however
QWord is not supported. In MySQL we have bigint unsigned = QWord in
FreePascal = unsigned long long in C++. The funny thing is that I can
get it like this: StrToQWord(field.AsString), but if I try to acces it
from AsBigInt property, I can't access it, I get exception.

The funny thing is that when using StrToQWord(field.AsString), it
works correctly even for values out of range of Int64 (where Int64 has
negative values). It means that when receiveing bigint unsigned from
database, field object stores it either as string or as QWord, but not
as Int64, but QWord is not accessible directly (there is no AsQWord
property)

----------------------------------------------------------------------
LacaK · 2014-08-08 05:41

Quote from: hinst on August 07, 2014, 04:26:18 pmThe funny thing is
that when using StrToQWord(field.AsString), it works correctly even
for values out of range of Int64 (where Int64 has negative values).
Interesting.
There are numeric values received as string from MySQL client library
and in mysqlconn is used StrToInt64 to convert it and store in record
buffer.
Can you test what result do you receive, when you use:
StrToInt64('your unsigned bigint value'); ?