Hi Hayashi,
I tried this, but it is givin' me SQLCODE -804 error, saying that both functions are defined. I'm new to Firebird. Will u plz. tell me what boiler plate code has to be written so that I'm able to use these functions.
Thanx.
Mahesh.

"Hayashi@..." <hayashi@...> wrote:
Hi all

SELECT
ROUND(-1.4),
ROUND((-1.4)),
ROUND(ABS(-1.4))
FROM
RDB$DATABASE
;

ROUND ROUND ROUND
============ ============ ============
-1 -1 <null>

SELECT
CEILING(-1.4),
CEILING((-1.4)),
CEILING(ABS(-1.4))
FROM
RDB$DATABASE
;

CEILING CEILING CEILING
======================= ======================= =======================
-1.000000000000000 -1.000000000000000 2.000000000000000


ROUND(ABS(-1.4)) returns 1 is correct I think?

I think it is caused by ABS() is in ib_udf and ROUND() is in fbudf. Is
this correct? Is this bug?

Tsutomu Hayashi in Japan
Mail : hayashi@...
Web : http://www.apex-jp.com/ (Japanese Only)
http://dmj.psnet.ne.jp/ (Delphi Magazine)



Yahoo! Groups SponsorADVERTISEMENT

To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.





---------------------------------
Yahoo! Plus - For a better Internet experience


[Non-text portions of this message have been removed]