Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
What is the best method ?
Message
 
 
À
02/12/2013 09:54:58
Mike Yearwood
Toronto, Ontario, Canada
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01588801
Message ID:
01589488
Vues:
80
Thank you so much. That is exactly right.

So, as you mentioned, it is where the change actually happened, and deal with it at that point.
Trying to do the tableupdate() or tablerevert() as part of Error Handling, does NOT work. It just loops.

The problem is, again as you guessed, this is happening once a day in 100's of transactions.
To figure out what the operator did? - is the challenge!.

Maybe I should put a tableupdate() every where there is a SEEK or a GOTO in the code?

Cyrus

>>Using VFP8 in Multi-User environment submitting changes via Transaction.
>>What is the best way to deal with:
>>
>>"Cursor cannot be modified because it contains unsaved changes" (error 2072).
>>
>>Error 2072 is not listed in VFP Help files. Can somebody explain exactly what is really happening?.
>>I know if there are unsaved changes in memory, I can submit them to disk using TABLEUPDATE() - or discard them using TABLEREVERT()
>>
>>What I am not sure exactly is the mechanics of how the table gets into this state?
>>
>>Thanks
>
>Somewhere code made a change to the cursor. It may be intended or accidental. Since the change was not handled with a tableupdate, you get this error. Where that change happened is what you need to find. Clearing the change with either tableupdate or tablerevert at the point of the error message is the wrong thing to do. That's dealing with a symptom, not the cause.
Cyrus Nima
-------------------
cyrusnima@gmail.com
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform