[V4RB] newbie on the loose

[Ruslan Zasukhin]

on 1/29/03 2:16 PM, Pedro fp at lists at pedro.net.au wrote:

>> Pedro, the good db design do not require adding of fields on the fly.
> 
> I wholly agree however some labs [this is scientific software] will
> want to add fields of their own [in-house meta-data] & I have to
> provide for that without knowing in advance what they are.
> 
>> May be better use for dynamic fields separate table.
> 
> That sounds just the way to go. Thanx :)

But then the best way:

    Table A -- is static
    Table B -- will have ObjectPtr to A, and that dynamic fields.

ObjectPtr must be unique, so you have 1 : 1 between tables.
This is in fact small inheritance made manually. :-)

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://listserv.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------