Yes you're right - I know of the example, and I "normally" solve it the
"old-fashioned" way with a detail table :-)

There might be things more "needed" than nested tables, but I could include
some other "nice-to-have" features:

External tables in different flavours (xBase, Oracle ...) - readonly would
be sufficient :-)
Backup/Restore via SQL.
a diffenrent "ISC4.GDB" solution...

...but now this mail should have been on the IB-Architect list :-)

Cheers
steffen

PS. It is also good for their marketing-guys :-)
Oracle 7 introduced Blobs - well IB had them for +15 years - sorry but I
have been working with Oracle and I've never been impressed, apart from how
long everything took (installation, backup and restore) - UPS now I will
get flamed :-)






Gerhardus Geldenhuis <linuxmail@...> on 02-02-2001 15:21:24

Please respond to IBDI@yahoogroups.com

To: IBDI@yahoogroups.com
cc:

Subject: Re: [IBDI] Nested Tables


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

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