This is a known problems with views. You cannot use a SELECT against a cursor. There are two workarounds that I am aware of:

One is to use regular FoxPro commands like SCAN/ENDSCAN, GATHER/SCATTER instead of SELECT to process the uncommited records in your cursor.

The second is to use a SELECT * FROM dbf('MyCursor') - This will retrive records from the physical table where the cursor is stored.

I have never felt comfortable with the second workaround, but perhaps you can take a closer look at it and see what works best for you.


>I have a view called V_Tickitm I created with the view designer and it is stored in my DBC.
>
>I need to run a select against this view but all Selects return an empty cursor.
>I imagine that this is because the view does not have a disk presence.
>
>Somehow I need to switch on the NOFILTER option of the view (If this is possible) and I can not do this from the view designer.
>
>I have tried modifying the view in the view designer, adding a new field which stores a value such as .T. to try and force a disk presence but this did not work.
>
>After opening my view with the NODATA clause I execute the following
>CursorSetProp("Buffering",5,'v_tickitm')
>
>I then let my users modify the view in preparation for writing it to the underlying table
>
>I do not want to have to write the contents of this view back to the underlying table to make my select work in case my user wants to cancel the changes they have made.
>
>
>All help gratefully received