|Subject||Re: [firebird-support] access column by column name|
On 12/26/15 5:18 PM, 'Walter R. Ojeda Valiente' sistemas2000profesional@... [firebird-support] wrote:
You can use EXECUTE STATEMENT for that.
On Sat, Dec 26, 2015 at 1:50 PM, slucas slucas@... [firebird-support] <email@example.com> 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))
SELECT "CN" FROM TABLE WHERE (DIV = :d) INTO :IC;
...MAYBE OTHER STUFF to IC...
UPDATE TABLE SET "CN" = :IC WHERE (DIV = :d);
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