> Please take a look at this script again
>
> "Select sum(Diff_Sum) As Total_Sum from Debt_Doc_Status"
>
> 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?

Yes, your inconsistent use of double quotes and case is more than likely a
problem. Tidy that up and it will help.

You also have incorrect format of the FieldsDisplayFormat property.

You have:
"Total_Sum=0.00"

And it should be:
"Total_Sum"=0.00

That's assuming you did it this way in the SQL. Otherwise, if no quotes then
this way:
TOTAL_SUM=0.00


HTH,
Jason Wharton