Page 1 of 1

Numeric Computed Field in FB 1.5 reported as LargeInt Field

Posted: 09.10.2009, 11:43
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

Posted: 09.10.2009, 21:29
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

Posted: 13.10.2009, 13:03
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