[firebird-support] access column by column name

2015-12-26 Thread slucas slu...@iquanta.com [firebird-support]
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 =

Re: [firebird-support] access column by column name

2015-12-26 Thread slucas slu...@iquanta.com [firebird-support]
aw, i like that. i've been using firebird/ib for so long i didn't even know that existed. thank you. lucas On 12/26/15 5:18 PM, 'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support] wrote: You can use EXECUTE STATEMENT for that. Greetings. Walter. On Sat, Dec

Re: [firebird-support] access column by column name

2015-12-26 Thread 'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
You can use EXECUTE STATEMENT for that. Greetings. Walter. On Sat, Dec 26, 2015 at 1:50 PM, slucas slu...@iquanta.com [firebird-support] wrote: > > > hello one and all, > > i would like to write a stored procedure which looks something like: > > CREATE