Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

using an array as part of a table

2 views
Skip to first unread message

Don Bowen

unread,
Jul 20, 2008, 9:20:50 PM7/20/08
to
if I define

list varchar(25)[3],

how do I then set list[2]='some value';

Firebird chokes when I attempt to set a value by referencing the
subscript... as list[2] or list(2) or list.2...

update student
set list[2] = 'fred'
where ID='0001';

why allow arrays if you can't set array item values?

thanks in advance for your help!
cheers,
Don B.

0 new messages