Limit on Unlinking/Linking Records
Ruslan Zasukhin
ruslan_zasukhin at valentina-db.com
Fri Aug 10 01:26:05 CDT 2012
On 8/10/12 9:21 AM, "Ivan Smahin" <ivan_smahin at paradigmasoft.com> wrote:
> There were some problems with that "multiple" (un)link statements - so there
> are some improvements and fixes in 5.0.
>
> Most important changes is:
>
> "EACH" clause must be mentioned explicitly!
>
> 1. LINK RECORD(1,2) .... WITH RECORDS(10,11).....
> In case of implicit "each" idea - there is a problem - what do I mean -
> (1,10)(2,11) OR (1,10)(1,11)(2,10)(2,11)?
>
> 2. LINK RECORD( ... some query ...) ... WITH RECORDS( ... another query ...)
> ....
> I don't know "cardinality" of that queries and it should not be a problem - I
> want to link that records strictly as I wrote - with or without "EACH".
>
>
> I'm not sure about 4.9.1 but it worse to try explicit "EACH" syntax.
> One more time, "EACH" means "crossing" behavior (the only valid one for
> not-matching size of record lists)
> "NO EACH" means "corresponded" behavior.
Aha, right.
This is link to wiki v5
<http://www.valentina-db.com/dokuwiki5/doku.php?id=valentina:vcomponents:vsq
l:reference:insert_link>
--
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]
More information about the Valentina
mailing list