Table.Field method

[Ruslan Zasukhin]

On 7/6/06 11:30 AM, "Joakim Schramm" <joakim at astrocalc.com> wrote:

>>> As an example, I have 1 group of 8 different values stored
>> in an UDT 
>>> and an
>>> array(34) As UDT. So just this batch of values will make
>> 280 fields I 
>>> one table.
>> 
>> Again, for arrays which keep values which you not need to
>> index you can use
>>     FixedBinary     -- good for array of fixed size
>>     VarBinary       -- good for array of var size
>>     BLOB            -- good for array of unlimited size
>> 
> Again, not sure how to go about to store and read this back in a proper way
> with VB6, doubt it's possible - at least not w/o an API I don't know about.
> Been thinking of CopyMemory API but locate vars in a "funny" way.

Well, I think your way with N records -- is BETTER and more correct from db
design 

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]