>Why does a
>APPEND FROM a FOR a.fieldx='F' append the whole table while
>APPEND FROM a FOR fieldx='F' appends only selected records?
When I try this, I get an error that alias A is not found. If I have table A open at the time, no records get appended. Your second APPEND works as expected and as you have observed.
Mark McCasland
Midlothian, TX USA