John,

The automatic "Select" was a feature of the Scan loop since the beginning of the Scan Loop. I believe that means Foxpro 2.6.

PF

>Hey UT folks -
>Sometimes I feel like a total idiot savant with VFP. Some features I know as well as the people who designed them, then I hit something like this .. which is probably something everyone but me knew about.
>
>Here's the feature I didn't know about, but came across by accident:
>
>Did you know that when you issue a SCAN/ENDSCAN VFP automatically flips a SELECT back to the correct file when hitting the ENDSCAN without you having to explicitly doing so?
>
>Here's an example program:
>
>SELECT j1
>
>SCAN
> SELECT j2
> LOCATE FOR ord = j1->rec
> IF NOT FOUND()
> APPEND BLANK
> REPLACE ord with j1->rec
> ENDIF
>ENDSCAN
>
>Now I would have expected this to bomb, because I didn't issue a 'SELECT j1' after the REPLACE and there's no 'ord' field on the 'j2' file. But when the program hits the ENDSCAN, it reverts to 'j1' automatically!
>
>Please someone tell me this is new and not been around since VFP 3 or FoxPro 1.0. Yeesh!