Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problems with multiuser
Message
 
À
17/07/2001 16:33:06
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00531740
Message ID:
00531759
Vues:
21
>Greetings all,
>
>I'm currently having data update problems in a multiuser environment. I'm guessing that this problem existed in earlier versions of our application but is quite apparent right now.
>
>When a single user creates or edits an invoice ( or order draft, etc..) everything is okay ( all the proper tables are being updated ) but as soon as we have multiple users editing and creating, sometimes a few of the tables won't be properly updated, for example, the numbers in the inventory will be wrong.
>
>I'm sure there is no "quick-fix" to this problem (but still hoping there is) but i'm looking for any ideas or things to watch for.
>Transactions are in use as follows when the user clicks the "Finish" button:
>Begin trans
>mess with data (replace, etc..)
>tableupdate(1, .f., 'sometable') (as many as needed.. also the error handler will alert me if update conflict occurs, which it hasn't, so I assume no update conflicts)
>end transaction
>
>sometimes many transactions will take place, with no messing with data between transactions.

How is your buffering set?
Eric Kleeman - EDS Consulting Services
MCP Visual FoxPro
MCSD C#.NET
Hua Hin Thailand
Los Angeles California
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform