>As I enter the filter conditions in my local view, I notice that the WHERE clause in the SQL command only shows the first condition + AND. I cannot save the 'corrupted' view, and reordering the conditions only causes the entire WHERE clause to disappear. I am using VFP 5.0a, patched with VSSP3.
Brett, I've had this happen several times as well. What I did was to remove the filter conditions below the one the does work and then re-add them. Then check your SQL Statement again. It should clear up. Also, you may want to add one filter condition at a time, then check after each one to make sure it takes.
John Henry
John Henry
State of Michigan