[V4RB] Outer Join Bug

[Ruslan Zasukhin]

on 11/15/03 4:52 PM, Frank Schima at frank-list2 at mindstarprods.com wrote:

Hi Frank,

> The latest V4RB 1.10 betas (b11 and b12) seem to have introduced a bug
> with Outer Joins.
> 
> Here is my SQL:
>   Select P.RecID, P.*, A.PaymentName, L.Name
>   From Purchase P, Account A, Location L
>   Where P.AccountPtr *= A.RecID and P.LocationPtr *= L.RecID
>   ORDER BY TransactionDate, PostDate
> 
> ViSQL says "Error 363 - Cannot Set Record Lock".
> 
> Going back to pre 1.10b11 works like it always has.
> 
> Note that when I remove the 2nd Outer Join - it works fine with b12:
> 
>   Select P.RecID, P.*, A.PaymentName
>   From Purchase P, Account A
>   Where P.AccountPtr *= A.RecID
>   ORDER BY TransactionDate, PostDate

In fact it can NOW works more correctly then before

Check your data and think if vl is right now.

If you think it is wrong send me simple db that reproduce problem

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------