Hi Armin,

Thanks for your quick response.

If I understand correctly, without NOFILTER, the result is not 'always' written to disk as a temp table and therefore can be inaccessible to subsequent queries ?

Just out of curiosity: how is it stored without NOFILTER (or the extra column) ? I'm just trying to understand the intermittent nature of the error.

Thanks again,

Henry





>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.

HTH,
Armin