You can use EXECUTE STATEMENT for that. Greetings.
Walter. On Sat, Dec 26, 2015 at 1:50 PM, slucas [email protected] [firebird-support] <[email protected]> wrote: > > > hello one and all, > > i would like to write a stored procedure which looks something like: > > CREATE PROCEDURE IC_INITIATE(d CHAR(3), CN CHAR(20)) > RETURNS (IC CHAR(22)) > AS > BEGIN > SELECT "CN" FROM TABLE WHERE (DIV = :d) INTO :IC; > ...MAYBE OTHER STUFF to IC... > UPDATE TABLE SET "CN" = :IC WHERE (DIV = :d); > SUSPEND; > END > > so CN is in quotes because i don't know how to pass a field/column name > as the CN parameter and then use that CN as an actual field in a table. > > how can i do that? thanx in advance and merry christmas. lucas > >
