--- In ib-support@yahoogroups.com, "Joseph Osende" <osendej@y...>
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
>
>
>
> Tél : +242 670808
>
> Mail : osendej@y...
>
>
>
>
>
> [Non-text portions of this message have been removed]