> I am inserting into SQL Server via a remote view. > > I am issuing TABLEUPDATEC) after every action but it keeps returning ".F." > > The record is inserted and it seems to be fine in SQLServer but the unique numeric key "ID" field that is automatically inserted by the SQLServer is always showing up in my view as "0" (when I BROWS > until I close the view and open it again then that field displays the coerrect numbers. > > I feel that I have to "refresh the view" somehow to get a ".T." from TABLEUBDATE(.T.,.T.) > > Any clues folks, if you need more details let me know. Are you also using transactions in addition to buffering? Do you have any trigger code in the remote table? What buffering scheme are you using? FYI, I assume you are using the identity clause in SQL server to generate your unique numbers, you can query this by SELECT @@Identity. Scot.