Hi Stefan

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