Subject | BigInt Delphi 10.2 Firebird Dialect 1 |
---|---|
Author | |
Post date | 2019-02-21T14:24:24Z |
Hi
I have just upgraded to Delphi 10.2 and IBO 5.10.1.
We use databases which are Firebird 2.5 dialect 1.
(For years we have had a project of upgrading to dialect 3, but there seems to come a lot in the way all the time).
Anyway - In my program I have this kind of code many places:
Q.Close;
Q.SQL.Clear;
Q.SQL.Add('select distinct SOMEFIELD from TABLE1');
Q.Open;
Q.FetchAll;
MultiValutaSystem := Q.RecordCount>1);
Q.Close;
And this resolves in this error:
ISC ERROR CODE:335544569
ISC ERROR MESSAGE:
Dynamic SQL Error
SQL error code = -104
Client SQL dialect 1 does not support reference to BIGINT datatype
I can see a ticket regarding BigInt in Delphi 5 - and a workaround.
Im unsure if I can do the same.
And how.
It would greatly help here.
Regards
Michael