Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Updating SQL server through Foxpro Remote Views
Message
From
14/06/2002 17:01:40
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Updating SQL server through Foxpro Remote Views
Miscellaneous
Thread ID:
00668792
Message ID:
00668792
Views:
98
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
Map
View

Click here to load this message in the networking platform