Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Update Conflict on a Text field
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00669548
Message ID:
00669758
Vues:
13
>>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform