There are two ways of doing this.
1. use VPF SPTs using SQLEXECUTE() function and pass the INSERT INTO statement
For example,
=SQLE(1,"INSERT INTO customer VALUE('1',12.33....)")
2. Use Remote View based on the table you want to update the data to.
Bye
Jayesh
>I am attempting to learn to use SQL Server .
>
>I am using SQL Server 6.5 Workstation and VFP 5.0. I have successfully created tables, deleted tables, and have cursed the user interface. I have been able to set up remote views and edit data. What I cannot seem to figure out is how to add new data from using the VFP front end. I know it's simple but unfortunately so am I.
>
>How does one add new data to an SQL table using VFP?
- Jayesh