General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Problems with multiuser
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.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only