>HI,
>
>I recently installed SQL-Server 7.0. I'm able to create tables in SQL server. I can also view the tables with connections and remote views.
>But what do I have to do to change or append records.
>Can Someone help me?
>
>Tnx
>

If you have a remote view, you can edit that data in the view, and then use the TableUpdate() command and VFP will send SQL commands to the database to update/add/delete any manipulations you did in the view... You can issue Requery() to see that the modified data has been saved on the back end.

You can also send your own commands to the back end using the SQLExec() function.

BOb