[TIP] Is there a way to create a M-M Binary Link in VStudio via a CreateLink dialog?

[Ruslan Zasukhin]

On 12/7/07 8:01 AM, "Barry G. Sumpter" <BarrySum at BigPond.Net.AU> wrote:

> Hi all,
>  
> I had to execute the following in VS 3.1 SQl Editor.
>  
> CREATE BINARY LINK link_Phone_Person ON TABLE (Person, Phone) AS MANY TO MANY;
>  
> The Table key word was NOT in the wiki and this statement would NOT execute
> until the word TABLE was added.
>  
> Is there a way to see the content of the LINK link_Phone_Person ?

We cannot see directly content of BinaryLink,
But since it keeps RecIDs of records, we can do something as

SELECT T1.recID, T2.recid
FROM T1 join T2

And you will get list of linked pairs.


Yes, it needs to think about

SELECT *
FROM link_Phone_Person



-- 
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]