Jump to content

Interbase Int64 support

Recommended Posts

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'.



Share this post

Link to post

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?






Share this post

Link to post

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.

Share this post

Link to post

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 by Fr0sT.Brutal

Share this post

Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now