Augusto,
The simplest way would be to do a remote view (which uses ODBC just like the SQLEXEC() does). Make the view updateable, and when users have finished changing it do a TableUpdate.
HTH
Barbara
>hi to all
>
>Im making an application in vfp6.0 who connects to a database that i create in microsoft acces
>that database has a table called "people" who has two fields
>
>name (character)
>age (numeric)
>
>in vfp6.0 i make a connection via odbc (who works fine) , netx, in the vfp comman window set the netx instructions
>
>=SQLEXEC(gnConnHandle, ' SELECT * FROM PEOLE ', 'MyCursor ')
>
>to get all the information about the records of the table people in a cursor called MyCursor.
>
>all its working in the rigth way (no problem)
>
>the thing its
>
>i need to make some changes in many names and ages i do it in " MyCursor " and i need to "transmit"
>this changes to the table PEOPLE.
>
>what commands i need to set or write to get that?
>thanks in advance
>best regards