--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:

>
> I'm running CS RC6 on RedHat 8 and the DOW function works just fine.
> You could query to see what declaration you actually have there.
>
> select rdb$function_name from rdb$functions
> where module_name = 'fbudf' or module_name='FBUDF';

it gives me the output

RDB$FUNCTION_NAME
================================
STRING2BLOB
DPOWER
INVL
I64NVL
DNVL
SNVL
INULLIF
DNULLIF
I64NULLIF
SNULLIF
DOW
SDOW
SRIGHT
ADDDAY
ADDWEEK
ADDMONTH
ADDYEAR
ADDMILLISECOND
ADDSECOND
ADDMINUTE
ADDHOUR
TRUNCATE
I64TRUNCATE
ROUND
I64ROUND

>
> AFAIK, the DOW function never was in ib_udf. However, at some point

in the

> RC's, SS went out with fbudf erroneously renamed to fb_udf. Perhaps

this

> is what you were thinking of.

seems you are right, maybe I mix it up with the udflib in
firbird/examples there is a dow function too.
unfortunately I can't exactly tell anymore from which UDF I got the
dow function which worked on my server. after installation of RC6 I
deleted all my UDFs and used the original ones which came with RC6
(ib_udf and fbudf).
I will give it a try to find and compile the sources of fbudf for
myself. maybe i can trace down a little bit more why fb-server crashes
on my box.

>
> I don't have SS installed at present: my other box is laboring,

with no

> apparent success, to reinstall Mandrake 9. I'm going to go to bed and
> leave it. With luck I'll be able to test it on SS tomorrow.

Thank you!

>
> heLen
>
>

alex