>>>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
ok Jeff... thanks.. that really helps.
after the TABLE is create, what will the code
look like to make an updateable table using the programatically approach?