Subject | How to display in TIB_GRID ? |
---|---|
Author | Zoran Zivkovic |
Post date | 2005-04-25T08:34:28Z |
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.
Thanks
Zoran Zivkovic
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.
Thanks
Zoran Zivkovic