Subject | Re: MORE Re: [IBO] TIB_DQSL problem |
---|---|
Author | Koby Peleg Hen |
Post date | 2003-05-29T08:19:17Z |
Helen Borrie wrote:
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?
--
Thank you for your time
Koby Peleg Hen
koby@...
> At 08:59 AM 29/05/2003 +0200, you wrote:Hello Helen
>
>
>>Hello Helen
>>I did what you told about setting the column itself to
>>"Rec_Count = 0.00"
>>And still no impact...
>
>
> Don't include space-characters around the "=" sign.
>
> Rec_Count=0.00
>
> Isn't Rec_Count an integer, anyway? Because integers have a precision of
> zero, you won't see any precision characters displayed. There should be no
> reason to include a FieldsDisplayFormat for an integer, since Delphi
> already displays it correctly.
>
> Helen
>
>
>
>
> ___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
> ___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info papers,
> keyword-searchable FAQ, community code contributions and more !
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
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?
--
Thank you for your time
Koby Peleg Hen
koby@...