>I tried to write SQL statement to create a view with a WHERE clause something like (x) OR (a AND b AND c). I reviewed the view in my Project. Said view did not have the parenthesis enclosing 'a AND b AND c'. The WHERE clause was therefore x or a and b and c. Is this a bug of VFP? How can I overcome this?
You'll run into a lot of problems like this with the view designer. Download the eView utility from hte files section here for an easy alternative.
Erik Moore
Clientelligence