Re: Transactin and Rollback.

What database are you using?

Setting the transaction isolation level after starting the transaction
does nothing. You cannot change the isolation level of an active
transaction.

Are you sure that dsetStockDoc is using the dtmpri.cnx_cv2
ADOConnection component?

--
Bill Todd (TeamB)
.

Relevant Pages

  • SQLite (with APSW) and transaction separate
    ... I want to use SQLite database like the FireBird database: ... transaction too, with same style. ... If ISOLATION LEVEL is low, the report can see the new subitems of the ...
    (comp.lang.python)
  • Re: ISOLATION levels and when to use SERIALIZEABLE
    ... Setting an isolation level tells SQL Server ... satisfy the where clause of a query in the transaction. ... acquiring KEY RANGE locks to protect a range of data in an index. ... select * into orders2 from orders ...
    (microsoft.public.sqlserver.programming)
  • Re: Pessimistic Locking
    ... > A normal select statement executed in a transaction with serializable ... > isolation level was still possible, ... > was called which should lock the row. ... > in a transacion with serializable isolation level and another client has ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SELECT statement behavior with Key Range Lock
    ... Your thoughts on the Serializable Isolation level are interesting. ... I stated it the Key Lock was a RANGEKey Lock (Shared range, ... you had an open transaction when you entered the procedure. ...
    (microsoft.public.sqlserver.server)
  • Re: transactions on reads?
    ... which is to say you needn't make it a transaction explicitly. ... --Run the codes in #1 ... select the isolation level explicitly enable dirty read, ... Davolio and #3 get a dirty data. ...
    (microsoft.public.sqlserver.programming)