Hi,

One small improvement.

Instead of

execute statement :loc_sql into :out_fecha;

I'd recommend

for execute statement :loc_sql into :out_fecha do suspend;

Reason: you can't be sure how many records :loc_sql will return, and if
that's more than one, you'll end up with the 'multiple rows in singleton
select' error.

regards
Tomasz

W dniu 2011-11-07 14:04, Sergio pisze:

> well... after doing my post I've found this..
>
> http://www.firebirdfaq.org/faq322/
>
> and I did this
>
> CREATE PROCEDURE PANIO_TERMINADO (
> in_id fk_id,
> in_etapa codigo)
> returns (
> out_fecha fecha_hora)
> as
> declare variable loc_sql descripcion;
> begin
> loc_sql = 'select ' || in_etapa || ' from pedidos_control where id = ' || cast( :in_id as varchar(10));
> execute statement :loc_sql into :out_fecha;
> suspend;
> end
>
> It's OK? or it can be improved? Thanks again!!!!
>
> -sergio
>
>

--
__--==============================--__
__--== Tomasz Tyrakowski ==--__
__--== SOL-SYSTEM ==--__
__--== http://www.sol-system.pl ==--__
__--==============================--__