Hmmm.....and in 1.0 the UDF's are not automatically loaded so I have to
use a script to load them all into the system?

R.

-----Original Message-----
From: Arno Brinkman [mailto:firebird@...]
Sent: Tuesday, July 29, 2003 3:09 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] MAX


Hi Robert,

For FB1.0 you can use UDF's for this.

I believe they are called xNVL() in the udf library.

> Sorry, I am using 1.0 because I need to support multiple

platforms and

> we cannot get 1.5 to compile for Solaris. In 1.5 I could use

NULLIF or

> COALESCE. As far as I can tell there are not available in 1.0.
>
> Is there a way, say in a sub select, to get the max of a

column OR ZERO

> if there are no records matching the criteria? I think

normally one

> would use Coalesce?

Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Firebird links :
http://www.firebirdsql.com
http://www.firebirdsql.info
http://www.fingerbird.de/
http://www.comunidade-firebird.org/


Nederlandse firebird nieuwsgroep :
news://80.126.130.81




Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://rd.yahoo.com/M=194081.3551198.4824677.1261774/D=egroupweb/S=1705
115386:HM/A=1663535/R=0/SIG=11ps6rfef/*http://www.ediets.com/start.cfm?c
ode=30504&media=atkins>

<http://us.adserver.yahoo.com/l?M=194081.3551198.4824677.1261774/D=egrou
pmail/S=:HM/A=1663535/rand=329390134>

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 <http://docs.yahoo.com/info/terms/> .




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