I am not very familiar with arrays but as I understand
you can must declare the size of the array when you
define the table.
The idea of a nested table would for example be an
address book where a John can have multiple phone numbers.
The phone number field would become a nested table type
and all the telno's would be inserted here.
This is not a good example but it illustrates my point.

Cheers Gerhardus

PS Oracle would not have had nested tables if they
didnt think it would be good for something :)

Steffen Nyeland wrote:

> Sorry for being a bit ignorant: But I have never understood what they
> (Oracles nestedtables) where good for. If Codd had thought it would be a
> good idea, he had put it in the RDBMS specs/rules. :-)
>
> BTW: The thing you are looking couldn't this be done with the existing
> Arrays in IB (They are great and huge, but only "surfaced" easily via
> IBObjects :-)
>
> steffen
>
>
>
>
>
> Gerhardus Geldenhuis <linuxmail@...> on 02-02-2001 14:39:39
>
> Please respond to IBDI@yahoogroups.com
>
> To: ibdi@yahoogroups.com
> cc:
>
> Subject: [IBDI] Nested Tables
>
>
> I dont know if this is the right maillinglist to ask so
> please correct me if I post it hear.
>
> My question is: Is their any posibility of interbase
> getting nestedtables in a future release like in oracle ?
>
> Cheers
> Gerhardus
>
>
> Community email addresses:
> Post message: IBDI@onelist.com
> Subscribe: IBDI-subscribe@onelist.com
> Unsubscribe: IBDI-unsubscribe@onelist.com
> List owner: IBDI-owner@onelist.com
>
> Shortcut URL to this page:
> http://www.onelist.com/community/IBDI
>
>
>
>
>
>
>
>
> Community email addresses:
> Post message: IBDI@onelist.com
> Subscribe: IBDI-subscribe@onelist.com
> Unsubscribe: IBDI-unsubscribe@onelist.com
> List owner: IBDI-owner@onelist.com
>
> Shortcut URL to this page:
> http://www.onelist.com/community/IBDI