At 10:19 AM 29/05/2003 +0200, you wrote:

>Hello Helen
>Please take a look at this script again
>
>"Select sum(Diff_Sum) As Total_Sum from Debt_Doc_Status"

I haven't seen it before. You gave us a dummy example before, so there was
no sign that you were (a) dealing with currency or (b) trying to display it
in a non-data-aware control.

>The "total_Sum" is define as numeric(18,4)
>The FieldsDisplayFormat is set to "Total_Sum=0.00"
>The output is connected into regular TEdit.text
>The field output is "123.0000"....
>Am i doing something wrong?

I can't tell from the bits and pieces of information that you are
providing. However, I suggest that, to do what you want for use in a
***data-aware*** control (treat a numeric as a binary-coded decimal with
two places), all you need is to set the "Currency" ColumnAttribute true for
this column.

However, if you are displaying it into a non-data-aware edit control, you
have no option but to format the Text property of the control yourself each
time the property changes, using Format() or FormatBCD(). TEdit doesn't
have any of the smart, datatype-aware display capabilities built into it
that the data-aware controls do.

Helen