Subject Re: date problem in stored procedure
Author paulhope@allcomm.co.uk
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)
> as
> declare variable date1 date;
> begin
> date1 = :adate; <- this line does not work. Why?
> suspend;
> end;
>
> Cheers
>
> Johannes