Is there a way to create a M-M Binary Link in VStudio via
aCreateLink dialog?
Barry G. Sumpter
BarrySum at BigPond.Net.AU
Thu Jul 12 00:04:08 CDT 2007
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/20070712/6055cf44/attachment.html
More information about the Valentina-studio
mailing list