LinkBinary

[Paxdo Presse]

Ok, thank you Ruslan, I'll see it all.

Le 18 nov. 2011 à 21:19, Ruslan Zasukhin a écrit :

> On 11/18/11 10:07 PM, "Paxdo Presse" <paxdo at mac.com> wrote:
> 
> Hi Oliver,
> 
> Good question.
> 
> 1) BinaryLink right cannot have additional fields, like can have regular
> table MM.  In this case you need use MM table as always.
> 
> 
> 2) We think that we can add one more
>        LinkOnTable   which in background will use MM table,
> 
> Advantage will be still that engine will know it as LINK,
> So we will be able still write short SQL queries with one joing between T1
> and T2 not thinking about T1 -> TL -> T2
> 
> 
> Also will be needed extend API of  Vlink class, to have Fields ...
> We still think about this ...
> 
> 
>> The linkBinary are very useful,
>> but what is the most effective solution to replace a link table M: M that
>> contains a field?
>> 
>> For example:
>> 
>> Table A: Type of Houses
>> - Field: Type (house of wood, brick house, etc.).
>> 
>> Table B: Owner
>> - Field: name of the owner
>> 
>> Table C: Link between owners and house types
>> Two fields:
>> - Owner ptr
>> - Type of house ptr
>> - NUMBER OF ROOMS
>> 
>> In this case, we are still working with three tables and classic links?
> 
> Yes.  Only you can use here RecID + ObjectPtr and still get some win in
> space and speed and easy ..
> 
> 
> -- 
> 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]
> 
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina