Andrus,

In VFP 6 SP 3 this inmediately generates an C000005 error. In VFP 7
SQL expression is too complex.

If you remove the .t. in the where clause, it runs fine. Also if you replace the left join with a inner join it seems to work.

The only conclusion I could draw, this behaviour is a BUG. Since this BUG is so easy to simulate, I strongly suggest to report this to the FoxTeam.

Walter,


>

>
>CREATE CURSOR alloweditems ( liik c(10))
>CREATE CURSOR artliik ( liik c(1))
>CREATE CURSOR toode ( f1 c(1))
>SYS(3055,2040)
>select * ;
>   from toode ;
>      left OUTER JOIN artliik ;
>        ON .f. ;
>   where .t. OR ;
>  (.f. AND artliik.liik in (select * from alloweditems ) )
>