Information générale
Forum:
Microsoft SQL Server
Titre:
Update Conflict on Memo fields.
Hi!
Just stumbled on a problem when updating a Memo field using an updatable cursor in VFP6 on an SQL Server platform. Using the VFP AERROR() command I was able to find that the TableUpdate() function returned false because of an error 1585 (Update Conflict).
A simple VFP statement like REPLACE Notes WITH "This is a big test." failed. I tried setting the VFP CursorSetProp "CompareMemo" property 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...! May sound like a faulty DLL or config glitch... Any idea?
Thanks for taking the time to respond...
Francois Bedard
Concept Studios
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement