shouldn't the line:

declare variable entie integer;

be

decleare variable entier integer;

HTH,

On 10 May 2003 at 1:03, Joseph Osende wrote:

> > Hi, List !
> >
> > I'm using Firebird 1.0.2.
> >
> > Could you please tell what's wrong with the following code in a
> stored
> > proc :
> >
> > declare variable entie integer ;
> >
> > entier = 10 ;
> >
> >
> > insert into sometable select atable.field1, :entier,
> atable.fieldn from
> > atable
> >
>
> did you try to specify the column names?
>
> insert into sometable (field1, field2, fieldn) select ... from ...
>
> >
> >
> > I've tried to cast ( :entier as integer )
> >
> > And always received the Datatype uknown error.
> >
> >
> >
> > Thanks in advance,
> >
> >
> > Joseph Osende
> >
> > BP 5975
> >
> > Pointe-Noire
> >
> > Rép. du Congo

--
George Boutwell,
Programmer II - Valley Hope Association
gboutwel@...