If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
array data type in table?
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 |
#2
|
|||
|
|||
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] |
Thread Tools | |
Display Modes | |
|
|