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

The view designer in Vfp7 and previous was quite limited.
You can use third party tools like eView and others, see also http://fox.wikis.com/wc.dll?Wiki~ViewEditor

Or modify your views programmatically - see also gendbc.prg, shipped in Vfp's
Home() folder.


hth
-Stefan