At 01:39 AM 29/07/2003 +0000, you wrote:

> >
> > SELECT
> > u.userkey,
> > SUM(U.PAYTOTAL) AS TOTAL
> > FROM MBUSERPAYMENT U
> > LEFT JOIN MBPAYMENT P ON P.PAYMENTKEY=U.PAYMENTKEY
> > LEFT JOIN MBPAYMENTDATA D ON D.PAYMENTKEY=P.PAYMENTKEY
> >
> > where D.PROVIDERITEMKEY=:pkey
> > AND P.STATUS=1
> > AND D.PAYFORYEAR=2003 AND
> > D.PAYFORMONTH=5
> >
> > group by u.userkey
> > having U.USERKEY=:ukey
> >
> > That's about all I can come up with...try it and see whether it
>works.
> >
> > Helen
>
>
>Hi Helen,
>Unfortunately no luck with that or any other variation of SQL I can
>think of, the strange thing is that if I run the same SQL in the
>IB_SQL console or Interbase PlanAnalyser the correct '-0.04' result
>is shown. Also results with 2 decimal places where the 2 digits are
>greater than zero, e.g. '-0.17' appears fine as well so its as
>though the minus in '.-4' is being put in the zeros place if the
>first decimal place is zero.
>I'll email you a small sample program if you'd like, but i run bcb6
>not delphi.

I don't have BCB at all.

Some things to look at if you haven't already...

Do you have anything at all in the FieldsDisplayFormat and/or EditMask
properties of the column?

What does the query look like in the monitor when it's prepared?

Are you by some accident trying to connect the IB_Edit/FastReport with a
TDatasource and/or TIBOQuery?

Helen