I know we are on an outdated version, but as I wrote, even if we were on a
newer version which has GTTs, I'm still interested (for the reasons stated in
the previous post) if Firebird supports the type of arrays I described. If it
doesn't its fine as well, it means I'll have to find a (bad) work
Thanks for the fast response.
That could be an option, unfortunately GTTs were added only in 2.1 (I'm running
on 2.0.6):
SQL> CREATE GLOBAL TEMPORARY TABLE SESSION_VARS
CON> (
CON> USER_UNIQUENUM integer NOT NULL,
CON> TICKET_UNIQUENUM integer NOT NULL
CON> )
CON> ON COMMIT PRESERVE ROWS;
Stat
Thanks for the answer, but the given link describes the array column type, so
I'd have to create a table to use it, and if I have to create a table, I can as
well create a table with the following structure: test_tab(key number, value
varchar(40)) which suits my needs.
What I'm asking for is
Hi,
Maybe this question was already answered, but I searched and couldn't find a
suitable answer. If so, please point me to an existing answer/FB document.
What I'd like to know is if Firebird (2.0.6) supports in-memory arrays in
stored procedures? The closest answer I found was here:
http://
