Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Update Conflict on a Text field
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00669548
Message ID:
00669758
Views:
12
>>I have an application that is in VFP 7 and tied back to an SQL Server 7 database. This past weekend some new data was converted over to it and we are now experiencing the "Update Conflict" that I have traced down to an individual field. It is a Text field and in all of the situations where it won't update there are large amounts of data in the Text field.
>>
>>Does anyone have any ideas on what could be causing this?
>
>My guess would be, that memo/text field are compared incorrectly in this case. Take a look at HOWTO: Use CompareMemo and Update Memo Fields mskb #Q157468 for how you can disable memo/text comparison. You can add some other field with timestamp to the Sql table to catch real update conflicts.

Sergey,

That was exactly the issue. Thank you so much for the quick response.
Rod Lewis
Previous
Reply
Map
View

Click here to load this message in the networking platform