Re: DataType for storing pointlist (x,y,z)?


"MP" <NoSpam@xxxxxxxxxx> wrote in message
news:u4N25P1kIHA.484@xxxxxxxxxxxxxxxxxxxxxxx
Greetings,

Using vb6, ado, writing to mdb format(jet 4.0)

If I want to store an array of 3 doubles, what would be best for the data
type of the field?

from Type Property (ado) in the help in vb6

Constant Description
adArray Joined in a logical OR together with another type to
indicate
that the data is a safe-array of that type (DBTYPE_ARRAY).

adVariant An Automation Variant (DBTYPE_VARIANT).
adVector Joined in a logical OR together with another type to
indicate
that the data is a DBVECTOR structure, as defined by OLE DB, that contains
a
count of elements and a pointer to data of the other type (DBTYPE_VECTOR).


would it be one of the above?
which one is better and why?

or would it be better to break the array into components and store each as
adDouble?
fldPtX
fldPtY
fldPtZ

most likely the incoming data will be either a variant containing an array
of (2 or 3) doubles
or the array itself (not wrapped in a variant)
I could massage this before sending to ado for putting in the database so
which would be more ...fill in the blanks <g> ...better, faster,
efficient,
???


It really depends on what these "doubles" mean and if you only have three or
many.

I would be sorely tempted to KISS it off, and store a primary key and then
store the doubles in another associated table. A simple getrows() could
provide a variant array.

-ralph
<g>


.

Relevant Pages

  • Re: Storing array of double. There must be an easier way.
    ... You can use GetChunk & AppendChunk methods of Field (ADO) object. ... > I would like to gather a sample of data, which consists of 5,000 doubles. ... I would store the data in a single field in a database. ...
    (microsoft.public.data.ado)
  • DataType for storing pointlist (x,y,z)?
    ... Using vb6, ado, writing to mdb format ... If I want to store an array of 3 doubles, what would be best for the data ...
    (microsoft.public.vb.database.ado)
  • Re: dynamic double array
    ... but you could store the doubles in ... Double and store them in the Vector and then later create an array of ... doubles whose size is equal to the size of the Vector and then one by ... the same size and one by one turn the Strings into doubles. ...
    (comp.lang.java.programmer)
  • Re: is this typedef valid?
    ... > i want to create a vector where each element is an array of 40 doubles. ... > DataSeriesType NewData; ... > essentially i want to store an array in a vector. ...
    (comp.lang.cpp)
  • is this typedef valid?
    ... i want to create a vector where each element is an array of 40 doubles. ... essentially i want to store an array in a vector. ...
    (comp.lang.cpp)