I can not get a record to add into an SQL table from Foxpro.

I can browse the SQL table in VFP (from my view), but when I try Append or Insert into, the records DOES show up and as long as that file is open, I can see the record. When I close and come back to the table, the record is GONE.

I even tried = TABLEUPDATE(.T.) and still the recotd is gone after I close the file. I have tried to add multiple records and they are all there unitl I close the file.

How do you add & delete records in SQL


I am using MS SQL 7 and VFP 6


THANKS