>Hi All,
>
>It has been awhile since I coded something using SQL Pass through. This morning I was trying to add a new record using one of my existing form. When I clicked on the "Save" button I noticed the data was updated according to the grid and I also checked the table to see if SQL updated the data using Enterprise Manager (it did). After I was done entering the data, VFP issue "Update Conflict" message when I typed 'close all' in the command window. Yet, when I issue =tablerevert(.t.) for that table, the data still remain in the table? Can someone help me out? TIA

Mathew,
Check out the following articles. One of them may help diagnose the problem:

MSKB#198606
MSKB#253886

HTH.