Web forum is in read-only mode. Login as active registered customer for write access
  Forum Search   New Posts New Posts

Int64 ID field generated as Numeric(18,0)

 Post Reply Post Reply
Author
Vitale Fabio View Drop Down
New Member
New Member
Avatar

Joined: 10 May 2016
Posts: 6
Post Options Post Options   Quote Vitale Fabio Quote  Post ReplyReply Direct Link To This Post Topic: Int64 ID field generated as Numeric(18,0)
    Posted: 17 Dec 2019 at 9:55am
Firebird 2.5

In data modeler I have defined an ID field  as BigInt in the table and Int64 in DataModeler's Aurelius Associations.

As soon as I call UpdateDatabase, Aurelius create the field as Numeric(18,0)

Is this an expected behaviour?
Back to Top
Vitale Fabio View Drop Down
New Member
New Member
Avatar

Joined: 10 May 2016
Posts: 6
Post Options Post Options   Quote Vitale Fabio Quote  Post ReplyReply Direct Link To This Post Posted: 17 Dec 2019 at 9:58am

Is there any difference between BIGINT and NUMERIC(18,0)?


No.


BIGINT was introduced by Firebird 1.5. If you aim compatibility with Firebird 1.0, use NUMERIC(18,0).

Back to Top
Wagner R. Landgraf View Drop Down
TMS Support
TMS Support
Avatar

Joined: 18 May 2010
Posts: 2693
Post Options Post Options   Quote Wagner R. Landgraf Quote  Post ReplyReply Direct Link To This Post Posted: 17 Dec 2019 at 12:56pm
So, question answered?
Back to Top
Vitale Fabio View Drop Down
New Member
New Member
Avatar

Joined: 10 May 2016
Posts: 6
Post Options Post Options   Quote Vitale Fabio Quote  Post ReplyReply Direct Link To This Post Posted: 17 Dec 2019 at 2:20pm
Yes: question answered.
I apoplogize for asking before googling a little bit :-)
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down