Numeric Computed Field in FB 1.5 reported as LargeInt Field

In this forum we will discuss things relating the ZEOSLib 6.6.x stable versions

Moderators: gto, EgonHugeist

Post Reply
Andry
Fresh Boarder
Fresh Boarder
Posts: 2
Joined: 08.07.2008, 15:49

Numeric Computed Field in FB 1.5 reported as LargeInt Field

Post by Andry »

Hello all.
I have two fields like this

Code: Select all

   TRA_CALC_TPT_TOTDOUANE  COMPUTED BY (((
        SELECT SUM(TRAFACT.TRP_MNTDDCALC)
        FROM TRAFACT
        WHERE  TRAFACT.TRA_ID = TRANSIT.TRA_ID
    ))),
    TRA_CALC_TPT_MNTDOUANE  COMPUTED BY (((SELECT SUM(TRAFACT.TRF_MNTDOUANE)
        FROM TRAFACT
        WHERE  TRAFACT.TRA_ID = TRANSIT.TRA_ID
        )))
these fields are numeric(12,2).
So with one TZquery, these two fields are reported as

Code: Select all

    qryTransitTRA_CALC_TPT_RAPPORT: TLargeintField;
    qryTransitTRA_CALC_TPT_PBRUT: TLargeintField;
Is this a bug ?

Thanks all
User avatar
mdaems
Zeos Project Manager
Zeos Project Manager
Posts: 2766
Joined: 20.09.2005, 15:28
Location: Brussels, Belgium
Contact:

Post by mdaems »

What version of zeoslib 6.6 are you using exactly? There was a fix in version 6.6.5 which should have adressed this, I believe.
Se http://fisheye2.atlassian.com/changelog/zeos/?cs=622

Mark
Image
Andry
Fresh Boarder
Fresh Boarder
Posts: 2
Joined: 08.07.2008, 15:49

Post by Andry »

Using zeos lib 6.6.2, i have this error.
So I have updated with the current stable version 6.6.5, but the problem remain.
I have created new project but the same problem remain.
Zeos Lib 6.6.5 Stable
Firebird : Server 1.5.3
EDI : Delphi 7 Entreprise
Post Reply