array data type in table?
On Wed, 29 Oct 2008 11:05:50 -0700 (PDT), djw
wrote:
I am pretty new to Access/VBA and do not really know SQL. I was
wondering if it is possible to use an array data type in a table?
I saw something online using SQL that was along these lines (in SQL
For Dummies):
CREATE TABLE CUSTOMER ( CustID INTEGER PRIMARY KEY, Phone CHARACTER
VARYING (15) ARRAY [3]);
I can create a table and fields using VBA & SQL but I cannot seem to
get an Array to work.
Thanks,
David
Access2007 (but not prior versions) allows an abomination called a MultiValue
Field. This code *might* be relevant to such a field, though I have not seen
code like it before; it would be interesting to know the context.
A multivalue field is actually implemented "under the covers" with a proper
one-to-many relationship to a second table; unfortunately that table isn't
exposed either in user view or programmatically, without a whole bunch of
rigamarole. Most serious developers would avoid ever using such a field.
--
John W. Vinson [MVP]
|