>>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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement