VStudio - Using Binary Links Instead of RecID etc.

[Barry G. Sumpter]

Nope, my bad.

After having a fresh look I can read the following: Work With Records
paragraph.

Which, I think is telling me I have to add another step to manage my own
Valentina Binary Index table.
More work, Although its binary and looks easy enough and will be faster.
Cool.  I'll have a go.

I had expected it to function like the Foreign Key fields.  
i.e. Just updating the index with the same update command using the Foreign
Key field name in the query.

---

Also, I'd like to read thru some more regarding the Field Method attribute.
So far I've just read about Method('RecID') and Method ('Concat(FirstName, '
', LastName))


Any other tidbits or hyperlinks would be greatly appreciated.


Thanks,
baz

--

Work With Records
Linking Existing Record
To link existing left and right records you need insert into Binary Link new
pair of RecID values you want to link. 

SQL EXAMPLE: 

INSERT INTO LINK link_Person_Phone VALUES( 1, 3 );API EXAMPLE: 

link2.LinkRecords( 1, 3 );Unlinking Records
To unlink some records you need remove from Link pair of RecID values. 

SQL EXAMPLE: 

DELETE FROM LINK link_Person_Phone VALUES( 1, 3 );API EXAMPLE: 

link2.UnlinkRecords( 1, 3 );






-----Original Message-----
From: valentina-studio-bounces+barrysum=bigpond.net.au at lists.macserve.net
[mailto:valentina-studio-bounces+barrysum=bigpond.net.au at lists.macserve.net]
On Behalf Of Barry G. Sumpter
Sent: Friday, 1 June 2007 5:00 PM
To: valentina-studio at lists.macserve.net
Subject: RE: VStudio - Can I make RecID my Primary Key? - I recommend - NO

Hi Ruslan,

Thanks for the direct respose.


Yes, funny you should mention that doco.

I have read thru some and attempted to nut out the Binary Link which reads
to be significantly faster than Foreign Key links.

But I found NO practical example of how the links actually worked.

i.e. I can create a Binary Link between tables (via v4RB samples) 
but no practical example of what it really is or to do next to use it.

i.e. more specifically what the links are actually linking on?

I'll need to chase down what you mean when you use the word "Refactoring".

Thanks,
    Barry G. Sumpter



-----Original Message-----
From: valentina-studio-bounces at lists.macserve.net
[mailto:valentina-studio-bounces at lists.macserve.net] On Behalf Of Ruslan
Zasukhin
Sent: Friday, 1 June 2007 4:29 PM
To: valentina-studio at lists.macserve.net
Subject: Re: VStudio - Can I make RecID my Primary Key? - I recommend - NO


And I wonder if you have read THIS pages:
 

<http://www.valentina-db.com/dokuwiki/doku.php?id=paradigma:public:en:docume
ntation:vkernel:vlink:vlink>


-- 
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-studio mailing list
Valentina-studio at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina-studio

_______________________________________________
Valentina-studio mailing list
Valentina-studio at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina-studio