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

[Barry G. Sumpter]

Hi All,

 

Assume you have two tables T1 and T2.

And binary link T1_T2 as M::1.

 

So

SELECT * FROM T1 LEFT OUTER JOIN T2

 

I can't seem to get the Valentina Studio v3.1 to build this OUTER JOIN for
me in the SQL Builder.

 

Does anyone know the correct sequence to build this OUTER JOIN  thru the SQL
Builder?

 

I've already tried to right click on the graphical link and selected "Select
all rows from T1" but the SQL continues to return "Inner Join".

 

Thanks,

     Barry G.Sumpter

 

 

  _____  

From: valentina-studio-bounces at lists.macserve.net
[mailto:valentina-studio-bounces at lists.macserve.net] On Behalf Of Barry G.
Sumpter
Sent: Thursday, 12 July 2007 3:11 PM
To: valentina-studio at lists.macserve.net
Subject: RE: Is there a way to create a M-M Binary Link in
VStudioviaaCreateLink dialog? 

 

Used google to find this:

http://www.valentina-db.com/dokuwiki/doku.php?id=paradigma:public:en:documen
tation:vsql:reference:insert_link

 

LINK RECORD(1) OF Person WITH RECORD(10) OF Phone USING PersonHasPone
LINK RECORD(1) OF Person WITH (10) OF Phone USING PersonHasPone

LINK (1) OF Person WITH (10) OF Phone USING PersonHasPone

 

  _____  

From: valentina-studio-bounces at lists.macserve.net
[mailto:valentina-studio-bounces at lists.macserve.net] On Behalf Of Barry G.
Sumpter
Sent: Thursday, 12 July 2007 3:04 PM
To: valentina-studio at lists.macserve.net
Subject: RE: Is there a way to create a M-M Binary Link in VStudio
viaaCreateLink dialog? 

 

My bad.

 

I TRIED to execute the following as well in VS 3.1 SQl Editor.

 

INSERT INTO LINK link_Phone_Person VALUES( 1, 1 )   

 

But received the error:  Unexpected token: LINK

Could someone respond with the correct syntax?

 

 

  _____  

From: valentina-studio-bounces at lists.macserve.net
[mailto:valentina-studio-bounces at lists.macserve.net] On Behalf Of Barry G.
Sumpter
Sent: Thursday, 12 July 2007 3:01 PM
To: valentina-studio at lists.macserve.net
Subject: RE: Is there a way to create a M-M Binary Link in VStudio via
aCreateLink dialog? 

 

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 ?

 

 

I TRIED to execute the following in VS 3.1 SQl Editor.

 

INSERT INTO LINK link_Person_Phone VALUES( 1, 1 )

 

But received the error:  Unexpected token: LINK

Could someone respond with the correct syntax?

 

Many thanks,

    Barry G. Sumpter

 

 

  _____  

From: valentina-studio-bounces at lists.macserve.net
[mailto:valentina-studio-bounces at lists.macserve.net] On Behalf Of Barry G.
Sumpter
Sent: Thursday, 12 July 2007 7:06 AM
To: valentina-studio at lists.macserve.net
Subject: Is there a way to create a M-M Binary Link in VStudio via a
CreateLink dialog? 

 


Hi all,


Is there a way to create a M-M Binary Link in VStudio via a Create Link
dialog?  


To me it would be like creating an ObjPointer but instead creating a M-M
Binary Link.


 


Binary Link Creation


To create a new Binary Link in database you send request to VDatabase
object. Database is supervisor of all its Links between Tables. 

SQL EXAMPLE: 

CREATE BINARY LINK link_Phone_Person ON (Person, Phone) AS MANY TO MANY;

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://edison.macserve.net/pipermail/valentina-studio/attachments/20070714/6f18f2bc/attachment-0001.html