using an array as part of a table

Thread View: borland.public.interbase.sql

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by Don Bowen Mon, 21 Jul 2008 01:20

#187

Author: Don Bowen
Date: Mon, 21 Jul 2008 01:20

18 lines
1357 bytes

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.

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads