[V4RB] Outer Join Bug

[Frank Schima]

Hi Ruslan,


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


Best regards,
Frank