FindAllLinked SQL

[Ruslan Zasukhin]

On 7/5/07 11:44 AM, "Bart Pietercil" <bart.pietercil at gmail.com> wrote:

Hi Bart,

>>     Vset FindAllLinked()
>> 
>> It returns Vset in some table.
>> SQL works with Joins using links.
> 
> 
> Since I need to work with a many-to-many relationship which was
> replaced with a binarylink, I don't have the necessary info to do a
> join in the traditional way (I need a many-to-many table for that)
> 
> Do I understand it correct that if
> 
> 1) one defines a binarylink (m-to-m)
> 2) one can no longer use the Valentina SQL way but has to use the API
> way

WRONG
 
> I can't believe that is true, that would be a huge omission in the
> SQL syntax.
 
> I must be missing something...

Yes,

Join now looks MUCH SIMPLER !!!

SELECT *
FROM T1 join T2 using blinkName
 
> If I have people and phonecalls (m-to-m) and store this info in a
> binarylink (as stated in the manuals), surely there must be an sqlway
> to retrieve for a certain person the phonecalls he has received ?

-- 
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]