>>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