DisplayFormat 1

[edwinjs]

I have a problem with DisplayFormat in Delphi7.

I have set the DisplayFormat for a Numeric Field to #,###,##0.00. if i input 100.15 it becomes 100.00.
I wonder why. I am using ClientDataset with SQL 2000 backend.

 

[Robertio]

My guess would be your DataType for the field in the FieldDefs of the ClientDataSet - check that it is a ftFloat. There is nothing wrong with your display format.

Robertio
Alias: Robbie Calder
Software Developer
urc@walkermartyn.co.uk

 

[edwinjs]

Datatype in SQL Server is "Money" and i am using DBExpress with DatasetProvider and ClientDataset. In clientdataset, it is "TFMTBCDField".

 

[LucieLastic]

Have you tried #,###,##0.0# ?

 

[LucieLastic]

I'll shutup, your display format should work.

 

[edwinjs]

The problem was with Infopower TwwDBEdit Component. I changed it to TDBEdit and everything works fine.

Lessons Learnt : Use 3rd party tools only when required.

Sorry !!! I assumed TwwDBEdit = TDBEdit

Thanks for the help anyway.