V4RB Binary Links

[Ruslan Zasukhin]

On 4/29/05 7:23 AM, "Anna Kritselis" <akritselis at earthlink.net> wrote:

Hi Anna,

> Hi Ruslan,
> 
> I'm trying to use Binary Links - and need some help.
> 
> THIS WORKS: Select * from Program, GradeLevel
> THIS WORKS: Select * from Program, GradeLevel, Classroom
> THIS WORKS: Select * from Program, GradeLevel where Program.RecId= 1
> CRASHES - I have to reboot machine: Select * from Program, GradeLevel,
> Classroom where Program.RecId= 1
> 
> Links:
> 
> mLink18 = new VBinaryLink( "linkProgramGradeLevel", mProgram, mGradeLevel,
> EVLinkType.kOne, EVLinkType.kMany )
> mLink19 = new VBinaryLink( "linkProgramClassroom", mProgram, mClassroom,
> EVLinkType.kOne, EVLinkType.kMany )

While we wait for your database, I want just mention, that you use
    implicit join - you do not specify names of links.

This is good, and this is even recommended way.

Just for info, that this query in the full form can be as:

Select 
    * 
from 
    Program join GradeLevel ON linkProgramGradeLevel
            join Classroom ON linkProgramClassroom
where 
    Program.RecId= 1


Again, you everything do correct, I just want to show the complete form,
which we must use if we have some ambiguity.


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