Helen,

Thank you, but I tried both proposed solutions, and nothing happened,
e.g. i still get same result in grid. Is it possible to do something
with "Display format" option (just gessing) ?

Regards

Zoran Zivkovic

--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@t...> wrote:
> At 08:34 AM 25/04/2005 +0000, Zoran Zivkovic wrote:
>
>
> >I have a folowing Query:
> >
> >SELECT DISTINCT PARTNO
> > , EAPARTNO
> > , FILTER_TYPE
> > , COMMENT
> > , ((CENOVNIK.SP*83*1.18)/1) AS MPC
> >FROM FILTER_PARTS
> >LEFT OUTER JOIN CENOVNIK ON
(FILTER_PARTS.EAPARTNO=CENOVNIK.EAPARTNO)
> >
> >Question: How to display value of column MPC in TIB_GRID with only
2
> >decimal places ? I get as result value 593.5164, and I dont know
how to
> >format display (or any other solution ?) as 593.52.
> >
> >I Use FB 1.5.2, database dialect 3. IBO Version 4.3Aa.
>
> In ColumnAttributes (of the column MPC in the dataset) set CURRENCY
to true;
>
> or set it in code:
>
> // Note: no spaces in the string!!
> MyDataset.ColumnAttributes.Add('MPC=CURRENCY=TRUE');
>
> Helen