Hi Mo,

Dragan is right, I meant to say that complex views, which work fine at runtime, might be to complicated for the View Designer in Vfp6 and 7.
In Vfp8 the designer was improved (but still cannot handle some sophisticated JOIN scenarios or any fancy IIF() in WHERE, as far as I know).
Your error message sounds as if its the designer who complains, as opposed to the Vfp runtime itself.

You could try if the View designer that comes with Vfp9 Public Beta is able to handle your particular views.


hth
-Stefan

> 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