Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problems with multiuser
Message
From
17/07/2001 17:45:19
 
 
To
17/07/2001 16:33:06
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00531740
Message ID:
00531774
Views:
11
>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.
>
>---
>Praying for a miracle, ;-D
>Jonathan Chan
>
>---
>Thanks all, UT has helped a great deal in the past and now I'm back for more ;-)
>One day, I hope to be able to help out as much as others have helped me.

Don't forget low-level stuff: is your network Novell, with older Novell client software on the workstations?
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Previous
Reply
Map
View

Click here to load this message in the networking platform