>>CREATE SQL VIEW myview AS SELECT * FROM testdata!customer;
>> WHERE country="Mexico"
>
>Thanks Jeff...
>I don't understand.. how would you change...
>
>SELECT * FROM TABLE INTO CURSOR ANYCURSOR
>
>to a view so I can edit it?
>
>rob

I'm still kind of new to VFP, and I'm not sure if this is what you are trying to do, but what I would do is:

CREATE SQL VIEW myview AS SELECT * FROM TABLE

This will create a local view of TABLE that you can make updateable using the View Designer or programatically. You can then use myview as the data environment of your data entry/update form.

Jeff