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
)))
So with one TZquery, these two fields are reported as
Code: Select all
qryTransitTRA_CALC_TPT_RAPPORT: TLargeintField;
qryTransitTRA_CALC_TPT_PBRUT: TLargeintField;
Thanks all