Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Updating Multiple Records with Multiple Users
Hello all,
I need some assistance with update logic. Currently I have a VFP6 application connecting to an Oracle 8 database. All view are created through SPT and I then use CURSORSETPROP to make the views updatable.
The problem that I am running into is that since this is a relational database multiple records in multiple tables must be updated at once. I am unable to force updates with TableUpdate due to business rules.
So here is my question. Is there some way that I can check each of the tables to see if any user has made an update to the table since I grabbed my view without having to do a second select and do a field by field comparison? I know table update generates an error if this happens but if I update half of the tables and then encounter an error I cannot undo the updates that I just made.
Any suggestions would be extremely welcome.
Thank you
Matt
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