Do you have the SQL Client Tools installed? If so, turn on SQL Profiler and see what is being sent the the server. You can then determine why it isn't. My guess is that VFP is sending an update statement that updates based on PK and changed fields.


>Hi All,
>
>I don't know if anyone encountered this problem before. I am currently using SQL pass thru with updatable columns. First time, entering and saving the data are fine, but if I go back to make changes to columns that were blanks before, VFP would not save changes made to the blank columns on the SQL server side. Does anyone know why? TIA