Re: Transactin and Rollback.

I use sqlserver 2000 and Delphi 2007

I correct the isolation level

There is no other connection.

thanks



"Bill Todd [TeamB]" <no@xxxxxx> escreveu na mensagem
news:47c46be5$1@xxxxxxxxxxxxxxxxxxxxxxxxx
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

  • 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)
  • Re: concurrent transactions
    ... The deadlock is normal with any isolation level (it was my mistake in the ... Because that you need a locking hint when executing the select: ... You execute this with RC isolation level and will be fine. ... So I don't need a serializable transaction? ...
    (microsoft.public.dotnet.framework.adonet)