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

> At 12:46 AM 24/09/2003 +0000, you wrote:

> >
> > select dow(timestampfield) from mytable
> >

> No; unless this is a snippet of a larger statement that has some

conflict

> with varchar(15) return parameter

no, I just trie this single select statement without success

> > But for what should be the
> >second varchar parameter???
>
> This is the declaration you should have:
>
> declare external function dow
> timestamp,
> varchar(15) returns parameter 2
> entry_point 'DOW' module_name 'fbudf';
>
> As you see, it specifies parameter 2 as the return parameter.

ok, this was my misunderstanding I expected a declaration like

DECLARE EXTERNAL FUNCTION dow
TIMESTAMP
RETURNS VARCAHR(15)
ENTRY_POINT 'DOW' MODULE_NAME 'fbudf';

The declaration I think is not the problem, because the function is
found but according to firebird log crashes the server (fbguard
abnormal termination)

>
> Which server version and model? Which platform is the server on?
>
> heLen

The Server is FB 1.5SS RC6 running on Debian Linux
Until now I used the older library ib_udf which still contained the
DOW function but now the DOW function is in fbudf but does not work
for me :/

alex