Interbase Int64 support

[Keesver 23]

Which data type should be used for Int64 values?

 

I tried Int64 and bigint, both return an error:

create table Test(ID Int64)

create table Test(ID bigint)

 

Error message:

Project IBTest.exe raised exception class EIBNativeException with message '[FireDAC][Phys][IB]Dynamic SQL Error
SQL error code = -607
Invalid command
Specified domain or source column does not exist'.

 

Thanks

[Jeff Overcash 2]

Try numeric(18,0).  InterBase does not have an alias for Int64 directly, but 18,0 is an int 64.

 

[Keesver 23]

ok, will do.

 

I was trying to use FDBatchMove + FDBatchMoveSQLWriter to import a table from MSSql into Interbase. The internal table generator uses 'Int64' for such fields, am I using the wrong generator?

 

 

Greetings,

Kees

[Jeff Overcash 2]

That would be a bug in FireDAC.  What you can do though is in your DB set up an Int64 domain that is numeric(18,0) and then it should go through.  I had a similar bug in IBExtract in IBX.

[Fr0sT.Brutal 900]

BIGINT is the SQL99-compliant 64-bit signed integer type

What's the problem?

 

NVM, noticed IB context. Funny that commercial DBMS has no such basic type

Edited February 28, 2022 by Fr0sT.Brutal