Subject | Re: date problem in stored procedure |
---|---|
Author | paulhope@allcomm.co.uk |
Post date | 2001-02-16T13:33:42Z |
you must have a return parameter when using suspend
create procedure Test (adate date) returns(date1 date);
begin
date1 = :adate;
suspend;
end
works. In IB5.6 anyway.
Regards
Paul
create procedure Test (adate date) returns(date1 date);
begin
date1 = :adate;
suspend;
end
works. In IB5.6 anyway.
Regards
Paul
> create procedure Test (adate date)
> as
> declare variable date1 date;
> begin
> date1 = :adate; <- this line does not work. Why?
> suspend;
> end;
>
> Cheers
>
> Johannes