Select * from A where field1 = "XYZ" BROWSEThe result looked OK. Then I used the following commands to append the result to table B.
SELECT B APPEND FROM DBF('query')And, I ended up adding the entire table A to table B! Now I try to attach NOFILTER to all queries. Perhaps VFP should have some default for NOFILTER setting.