At 05:22 PM 18-02-01 +1300, you wrote:

>Helen Borrie wrote:
> >
> > At 04:30 PM 18-02-01 +1300, you wrote:
> >
> > >The reason why I had a look at mer's udflib is I need a 'diffdate'
> > which
> > >I did not find so far elsewhere. I need the number of days between
> > any
> > >two dates as in 'diffdate = abs(date1 - date2)';
> >
> > You don't need a UDF for this - you can do it in DSQL with SQL
> > arithmetic and the shipped abs() UDF:
> >
> > select <fieldlist>, abs(date1 - date2) as diffdate from aTable
> >
> > This returns a double which is in days.
>
>Thank you for the hint, but I need it in a stored procedure.

So why can't you do this in a stored procedure?

create procedure whatever
as
declare <all sorts of variables>
...;
declare variable DateDiff: double;
begin
for select <fieldlist>, abs(date1 - date2) from aTable
into <all sorts of variables>, :DateDiff
do
begin
blah blah;
...
end
end

>Just tried
>it with 'IBConsole' and it appears to work, but the confusing part came
>from ???'IBExpert 1.0.068'??? and its stored procedure debugging tool,
>which obviously is slightly flawed.

Well, the IBExpert people watch this list - what happened in the debugging tool?

Cheers,
Helen

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________