Hi!

Just stumbled on a problem when updating a Memo field using an updatable cursor in VFP6 on an SQL Server platform. Using the AERROR() command I was able to find that the TableUpdate() function returned false because of an error 1585 (Update Conflict).

A simple statement like REPLACE Notes WITH "This is a big test." failed. I tried setting the CursorSetProp "CompareMemo" to .F. in order to have a different behavior (based on some reading done on Microsoft's site), but to no avail.

Now what's very interesting is that I get these Update Conflicts only when running my program on the server, when I connect remotely from my workstation, everything works fine...! Any idea?

Thanks for taking the time to respond...


Francois Bedard
Concept Studios