Good day
-\==0=-0=
I saw this posting on a newsgroup server

//==============================

> why is it not recommended to use array fields???

They are barely supported -- you can do almost nothing with them in
straight SQL, and forget about exposing them via ODBC or OLE-DB -- and
they don't conform well to the relational model.

//===================================

This raised the question in my head, is this true. As I understand
array fields can be handy in the following 2 aspects

A) Saves space for mini master - detail relationship information
B) QUICK in the 'A' scenario where the detail information is required. Do
not need extra table to access

Thus there MUST be a need for them to be created from the beginning anyways
correct ??

I just wondering what is the lists views on this ??

Thanks in Advance for any comments

Johannes Pretorius

----------


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.672 / Virus Database: 434 - Release Date: 28/04/2004


[Non-text portions of this message have been removed]