[V4MD2] ObjectPtr in thirdTable: example request

[info at vallemediatime.com]

Hi Ruslan,

> Paolo, do you want to study this new feature of 2.0 ?
> Then check our examples about binary link, and read docs about it
> Using binary link you just DO NOT need third table.

Binary links are a good way but in my test I've found some issues
I've modify your link_binary_example and now I send it to you, in the
example you can see some issues and question....

> WOW2: guys, this bring us to new parameter of BinaryLink:
>                 allow duplicate pairs.
Right, but I don't want duplicate pairs.
Paolo

----- Original Message -----
From: "Ruslan Zasukhin" <sunshine at public.kherson.ua>
To: <valentina at lists.macserve.net>; "Ivan Smahin"
<IvanSmahin at public.kherson.ua>; "Frank Schima" <macsforever2000 at yahoo.com>
Sent: Saturday, April 09, 2005 6:03 PM
Subject: Re: [V4MD2] ObjectPtr in thirdTable: example request


> On 4/9/05 6:48 PM, "info at vallemediatime.com" <info at vallemediatime.com>
> wrote:
>
> Hi Paolo,
>
> > Hi Ruslan and Igor
> > I look for make example to prevent that a Phones comes assigned to the
same
> > person...
> > I think that I must do a third table... right?
>
> right
>
> > PERSON
> > 1  Ruslan
> > 2  Igor
> > 3  somebody
> >
> > PHONES
> > 1  11111
> > 2  22222
> > 3  xyz
> >
> > PERSON_PHONES
> > 1 PersonPtr   -- is a virtual value?
>                    ^^^^^^^^^^^^^^^^^^^^ why? No. Regular ObjectPtr
> > 2 PhonesPtr
> > 3 Person+Phones (CONCATE...) ???
>
> I see.
>
> You can make third field as
>
>     person_phones of ULLONG type, unique
>         as method  (PersonPtr << 32) + PhonesPtr
>
>
> > How I can assign the PersonPtr and PhonesPtr from a GUI menu?
>
> GUI of what ?
>
> > If I delete one person I must delete his Phone and Ive undestand that I
must
> > use (cascade deletion, etc.), right?
>
> You can set CASCADE for PersonePtr. But this will force deletion of
records
> for PERSON_PHONES only.
>
> Records of Phone table cannot be forced to be deleted, because PhonesPtr
> point as M to 1.
>
> WOW. We have discover another advantage of BIANRY LINK !
> Binary link can do M : M and can kill phone records.
>
> Paolo, do you want to study this new feature of 2.0 ?
> Then check our examples about binary link, and read docs about it
>
> Using binary link you just DO NOT need third table.
>
> WOW2: guys, this bring us to new parameter of BinaryLink:
>
>                 allow duplicate pairs.
>
>
> --
> 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
>
>
>
> --
> No virus found in this incoming message.
> Checked by AVG Anti-Virus.
> Version: 7.0.308 / Virus Database: 266.9.5 - Release Date: 07/04/2005
>
>



-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.9.5 - Release Date: 07/04/2005