Subject Re: [firebird-support] fbudf - dow syntax
Author Helen Borrie
At 12:46 AM 24/09/2003 +0000, you wrote:
>Hi,
>
>can someone tell my how the dow or sdow function in fbudf works
>correctly?? I tried a
>
> select dow(timestampfield) from mytable
>
>but it does not work. only a sandclock shows and after a while I get
>an error "connection lost to server..."...
>Am I using wrong syntax??

No; unless this is a snippet of a larger statement that has some conflict
with varchar(15) return parameter

>in the function declaration I can see two
>input paramters, timestamp

is the sole input parameter

>and a varchar.

is the return parameter

> 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.

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

heLen