Helen. I´ll try, but anyway, why?

A similar behaviour occurs inserting a single char constant:

insert into Table values('A') gives conversion string error, but

insert into Table values(cast('A' as varchar(1))) works fine ...

(probably the answer is not shared by both questions, but I want to know :)

Thanks!

2009/9/14 Helen Borrie <helebor@...>

> At 03:34 AM 15/09/2009, you wrote:
> >Following there are two versions of a simple SP (stripped down of a more
> >complex real case):
> >
> >1)
> >CREATE PROCEDURE SP_GENERAR_TRANSFERENCIA (
> > OBSERVACIONES Varchar(2500)
> >)
> >AS
> > insert into transferencias values(:observaciones);
> >end
>
> Have you tried
> insert into transferencias values( (:observaciones) );
>
> ./heLen
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>
>

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