Hi Ruslan,<br><br>Thanks so much, this will really help streamline what I'm doing.<br><br>Gotta love Valentina, not only is it super fast, but so is it's customer support :-))))<br><br><div class="gmail_quote">On Thu, Jul 15, 2010 at 8:01 PM, Ruslan Zasukhin <span dir="ltr"><<a href="mailto:ruslan_zasukhin@valentina-db.com">ruslan_zasukhin@valentina-db.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><div class="im">On 7/13/10 3:15 AM, "Kay C Lan" <<a href="mailto:lan.kc.macmail@gmail.com">lan.kc.macmail@gmail.com</a>> wrote:<br>
<br>
Hi Kay,<br>
<br>
</div><div class="im">> If you add this feature, could you also make it symmetric:<br>
><br>
> UNLINK (1) of Person FROM (ALL) of Phone<br>
><br>
> UNLINK (ALL) of Person FROM (1) of Phone<br>
><br>
> Thanks<br>
<br>
</div>FYI<br>
<br>
We implementing this right now.<br>
<br>
It will NOT be symmetric as above, just because they current grammar allow<br>
EACH keyword only for the right part.<br>
<br>
Feature you have asked for will looks as<br>
<br>
UNLINK RECORD (1) OF T1 FROM EACH RECORD OF T2;<br>
UNLINK RECORD (1) OF T1 FROM RECORDS OF T2;<br>
<br>
UNLINK RECORD (1,2) OF T1 FROM EACH RECORD OF T2;<br>
UNLINK RECORD (1,2) OF T1 FROM RECORDS OF T2;<br>
<br>
<br>
I.e. Just skip on the right side IDs, and this will mean unlink from all<br>
linked for specified left record(s)<br>
<br>
Note, that word EACH also will be optional here.<br>
<br>
<br>
WIKI, Mantis and BLOG will be updated about this feature soon<br>
<font color="#888888"><br>
<br>
--<br>
</font><div><div></div><div class="h5">Best regards,<br>
<br>
Ruslan Zasukhin<br>
VP Engineering and New Technology<br>
Paradigma Software, Inc<br>
<br>
Valentina - Joining Worlds of Information<br>
<a href="http://www.paradigmasoft.com" target="_blank">http://www.paradigmasoft.com</a><br>
<br>
[I feel the need: the need for speed]<br>
<br>
<br>
_______________________________________________<br>
Valentina mailing list<br>
<a href="mailto:Valentina@lists.macserve.net">Valentina@lists.macserve.net</a><br>
<a href="http://lists.macserve.net/mailman/listinfo/valentina" target="_blank">http://lists.macserve.net/mailman/listinfo/valentina</a><br>
</div></div></blockquote></div><br>