Remove the : before adate.

Only use a colon when using variables in SQL statements.

eg...
date1 = adate; <--no colon

select count(*) from atable
where datefield = :adata <--use colon
into :rowcount; <--use colon

----- Original Message -----
From: "Jay" <johannes@...>
To: <IBObjects@yahoogroups.com>
Sent: Friday, February 16, 2001 12:45 PM
Subject: [IBO] date problem in stored procedure


> create procedure Test (adate date)
> as
> declare variable date1 date;
> begin
> date1 = :adate; <- this line does not work. Why?
> suspend;
> end;
>
> Cheers
>
> Johannes
>
>
>
>
>