>I had a situation with a method which executes the following code

>SELECT rpt.*,inv.u_of_meas ;
>  FROM crsReport rpt ;
>    LEFT JOIN inventor inv ON rpt.uniq_key = inv.uniq_key;
>  INTO CURSOR crsReport READWRITE
>
>REPORT FORM reports\pick_by_seq TO PRINTER PROMPT PREVIEW NOCONSOLE

>
>I was getting a "Variable Not Found" error.
>
>I checked and the current ALIAS() was crsSchedule.
>So I put in an explicit
>SELECT crsReport
>immediately after the Select statement.
>
>"Variable Not Found".............
>
>I was aware of situations where the Report Writer is not happy when focus is on a grid so I made the first line of the method

>thisform.txtBuild.setFocus

>
>This solved the problem until yesterday. I had re-compiled the app and the problem re-surfaced. Immediately after the SELECT SQL statement the active cursor was no longer the one specified by the INTO CURSOR claus.
>
>I changed the SETFOCUS() at the beginning of the method from the TextBox to a Command Button and all was well again.
>
>Does anybody have an explanation of why the INTO CURSOR does not become the active work area?
>
>Absent an explanation of why.......is there something that lists the conditions which could cause this situation?

The easiest way to figure out what's causing it is to put ALIAS() in the Watch window and set a breakpoint on it.

Tamar