Hi Terry

That was just an example with the typo. that's not the problem.

Thanks
Mo

>Mo
>
>Not sure if this is a typo of yours (and just a generic example) but
>
>colname IN (select xxxx for tablexxx where colyy = ?xxx)
>
>shouldn't it be
>
>colname IN (select xxxx FROM tablexxx where colyy = ?xxx)
>
>Terry
>
>
>>Using VFP7, I get this error "SQL syntax is too complex" when I try to modify a view.
>>The only thing that maybe the problem is I have in teh WHERE clause an IN that looks like
>>
>>colname IN (select xxxx for tablexxx where colyy = ?xxx)
>>
>>It seems like the view works fine but is this a bug???
>>
>>Thanks
>>Mo