Subject BigInt Delphi 10.2 Firebird Dialect 1
Author

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