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