Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
TableUpdate not updating/ Local Views/ Update Conflict
I created the local view "lvProduction" based on two other local views..."lvProduction_a" and "lvProduction_b".
Local view "lvProduction" is diplayed using a grid on two different screens (forms). The Production screen (seperate executable) and the Weigh screen (seperate executable).
When an operator completes the fabrication of a product that product is entered to the Production table immediately. The product then moves to the Weigh station to be weighed.
I add a record to the production table correctly through "lvProduction" by sending SQL Updates within the Production screen. I also get the weight to the appropriate product/record again using the same SQL updates from "lvProduction" from the Weigh screen
My problem is that if I try to edit that particular product/record again from within the Production screen VFP crashes because the TABLEUPDATE() failed and I receive an "Update conflict" error message?
Does anyone know why this is going on?
Thanks in advance!
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