Hi,

>1- Is it not true that the cursor is going to be created regardless of
>whether or not it has results in it ? (line 42 error)

A cursor is created, regardless, if the result contains a record or not.

>2- Considering that the app exists after an error; how can line 110 have
>that error if line 42 didn't crash

>3- Same app, same data, different days will either work fine or have one of
>the 2 errors !!!

>Note that all these lines are in a Scan loop and run every time. They are
>NOT skippable with IF or other constructs.

You could try and add the NOFILTER keyword to the SELECTs, so the cursor is going to be stored in a temp. table in any case. Alternatively, in VFP6 you can add a constant like .T. as an additional column to force VFP to create a temporary table instead of a filtered "view" on the base tables.

HTH,
Armin