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