General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>Not quite sure that this is what you're looking for:
>I have found that despite what the help file says TXNLEVEL() is scoped to the DATASESSION somehow. If you BEGIN TRANSACTION in one DATASESSION, change datasessions and check TXNLEVEL(), it shows 0.
>
>
I try to be little more specific... When I call the code in the another object, TXNLEVEL() indicates that the transaction is active (TXNLEVEL() = 1).
I'm quite confused because the tables are visible in all objects and the debugger shows that TXNLEVEL() is more than 0.
I have tested my code in situations where two users start almost simultaneously an update, which launches this transaction. It updates five tables. In situation where the code is written directly into object another update fails and rollback&error message routine gets called. It works fine.
But when I move the code in another object, partial updates occur and I get "update conflicts". Like there was no transaction at all. I am not sure can "update conflicts" happen within a transaction, but no partial updates anyway.
My goal is to create a class that provide transaction management. That's why the ability to call others object's methods is important. (So that the transaction works, of course:))
Hope this made the picture clearer...
Thanks for your reply!
Previous
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