General information
Title:
Updating SQL server through Foxpro Remote Views
I'm updating 2 Sql Server tables using Remote views in FoxPro. I start a Transaction and I select the first remote view, update it (tableupdate(2,.f.)), if successfull, I select the second remote view, update it. If not successful, I rollback the transaction and tablerevert each table. The first remote view which is made up of a Sql table with all the line items updates without a problem, the second table which is the header table however, gets an UPDATE CONFLICT. Any idea what could be causing this problem. What should I look for. This has worked fine the past few months but is a problem now. My code has not changed and the tables structures have not changed.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only