|
Hi, I'm a little confused about the method to make transactions in sapdb (working with autocommit; isolation level committed) trough odbc.
I've a base table with 16 records and test it trough 2 pc:
PC1) SELECT * FROM table1
16 rows -> ok
PC2) SELECT * FROM table1
16 rows -> ok
PC1) SUBTRANS BEGIN
-> ok
PC1) INSERT INTO table1 (pk, desc) VALUES (17,'17')
-> ok
PC2) SELECT * FROM table1
Waiting... (There is a table lock) -> ok
-> ok
PC2) SELECT * FROM table1
Waiting... -> That's wrong, the table must be free �?
After this, PC2 is still waiting then I make SUBTRANS END (for example) on PC1; this makes an error (obviously), but PC2 now is free and there is only 16 records not 17, any clue?
I'm from Argentina, my natural language is spanish, sorry if there is many spell errors ;+)
| 