Hello, Fabiano.



Thank you for trying to help me.



Yes, I’ve tried to use column names.



Joseph

-----Message d'origine-----
De : fabiano_bonin [mailto:fabiano@...]
Envoyé : vendredi 9 mai 2003 15:46
À : ib-support@yahoogroups.com
Objet : [ib-support] Re: Datatype uknown error in a stored proc



--- 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]

[Non-text portions of this message have been removed]