Trouble with Binary links

[Ivan Smahin]

Hello Alex,

Tuesday, September 18, 2007, 11:29:43 AM, you wrote:

> Hi Ruslan

> Just started playing with binary links and am having mixed results.

> I've put a small & simple test database together at:
> http://www.harryscollar.com/binarylinktest.zip (only 12KB)

> The main database is called "test.vdb" & there are two sql queries 
> displaying the problem.

> "query1.sql" displays all the linked items ok (6 in total)

> "query2.sql" tries to display linked items based on a simple where 
> clause but gives an incorrect result, I get 2 results instead of the 
> required 3.

> If you change the where clause to:
> where infozones.zonename = 'zone 2' OR
> where infozones.zonename = 'zone 3'
> Then I get no results, when clearly it should return 2 or 1 items 
> respectfully.

> This has been tested with Valentina Studio 3.2 & 3.3(most recent) on 
> both mac & pc.

> What am I doing wrong?

Seems to be a bug. Would you like to report it to Mantis?


-- 
Best regards,
Ivan Smahin 
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com