If you have complex expressions where you have the .f. and .t. in this example, then you are running into the line length limit most likely. Is this select used inline ina program like the example, or are you assigning it to a variable? There are two limits, 8192 characters for a single command line, and 255 characters for a string literal.

Randy

>

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