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