Luc,

I just tried this also , and I receive a error:
'543.567' is not valid integer value. (value of column I want to
format).

I don't know what could be wrong.

If someone now why I am receing this error, please let me know.

Regards

Zoran Zivkovic

--- In IBObjects@yahoogroups.com, Lucas Franzen <luc@r...> wrote:
>
> Zoran,
>
>
> Zoran Zivkovic schrieb:
>
> >
> > 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.
>
> In addition to what Helen already told you you can also use the
display
> format property of the TIB_Query.
>
> Open it, prepare the statement, change to the FieldProperties page,
> select the field MPC and enter the appropriate display format, i.e.
> #,###0.00 if you want to show it with a comma as thousand
separator, a
> dot as the decimal separator and a precision of two digits.
>
> In general: Just enter the "delphi"-format string for your field
and it
> will be formatted accordingly on display.
>
> (If you have more than one field with that format, you can mark all
the
> fields (multiselect) and enter the format string then; it will be
> assigned to all the selected fields then)
>
>
> This is valid for all formatting.
> For example, if you want to format a datetime field you can enter:
>
> dd.mm.yyyy [hh:nn:ss]
>
> and it will will show as
>
> "25.04.2005 [11:22:06]").
>
> Luc.