The VD (not what you may think - I mean the View Designer) is surely improved in 8; haven't played with it too much so I can't tell you how exactly.

I think he meant you may not have this problem if you create your views programmatically, using one of the independent view editors. That's the major reason why I can't tell you much about VD, because I had maintained my views that way for a number of years. I use VD only to create a new simple view - but don't edit it there afterwards.

>Do you mean that I may not have this problem in VFP8???
>
>Mo
>
>>> 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