Hi,

I am using VFP6.0 and SQL Server 7.0.

I get an Update Conflict error when attempting to update a remote view, when a user changes a record, with a TableUpdate(). Actually, when I go into debug at a point before the Begin Transaction starts, and the TableUpdate() and try to browse the view, I also get the error.

I have researched the view and found that the ID Number field that VFP is trying to update is an ID number from a different view on a different table!! That ID number does NOT exist in the view I am trying to update, yet I get that error (which is a good thing I think because it is the wrong ID number).

The remote view I am trying to update only has the ID number as the primary key, and it, nor the timestamp field, is selected as updatable. Send SQL updates is selected and if I uncheck that, I of course don't get the error.

Any ideas? Let me know if any one needs more specifics, or code posted.

Thanks,

-paul