>It is the same reason I always have a SELECT TableAlias as the last line of a set of instructions inside a SCAN ... ENDSCAN, because on occasion VFP forgets what table it is scanning when it hits the ENDSCAN.


No, VFP does not "forget" the alias it was working on when it hits an ENDSCAN. The last time there was a problem with that was one of the early builds of FP2.0. If you're seeing that in any later version, I'd sure like to see some code that replicates it. I never have in VFP.