Subject | selecting a field by name (using a var) |
---|---|
Author | Sergio H. Gonzalez |
Post date | 2011-11-07T13:50:31Z |
Hello! I use FB2.5. It is possible to have an SP in which I send a
string as input paramemeter and I get the value of some field named as
my input parameter?
CREATE PROCEDURE PANIO_TERMINADO (
in_id fk_id,
in_etapa codigo)
returns (
out_fecha fecha_hora)
as
begin
select /* (in_etapa as a field name !!!??? )*/ from pedidos_control
where id = :in_id into :out_fecha;
suspend;
end
Thanks!!!
-sergio
[Non-text portions of this message have been removed]
string as input paramemeter and I get the value of some field named as
my input parameter?
CREATE PROCEDURE PANIO_TERMINADO (
in_id fk_id,
in_etapa codigo)
returns (
out_fecha fecha_hora)
as
begin
select /* (in_etapa as a field name !!!??? )*/ from pedidos_control
where id = :in_id into :out_fecha;
suspend;
end
Thanks!!!
-sergio
[Non-text portions of this message have been removed]