SqlTransaction problem

[Neven Klofutar]

Hi,

I'm trying to retrieve some information from DB using SqlTransaction, but I
have a problem.
I'm executing some DELETE SQL statements using Transaction. Then later on
(because of the lousy project) I need to read the same information from DB
that is beeing deleted using the same transaction.

Is it possible to delete data, and read the same data in one SqlTransaction,
or that Transaction cannot read the data anymore even if Commit() haven't
been executed jet ?

thanx, Neven

 

[David Browne]

Hi,

I'm trying to retrieve some information from DB using SqlTransaction, but
I have a problem.
I'm executing some DELETE SQL statements using Transaction. Then later on
(because of the lousy project) I need to read the same information from DB
that is beeing deleted using the same transaction.

Is it possible to delete data, and read the same data in one
SqlTransaction, or that Transaction cannot read the data anymore even if
Commit() haven't been executed jet ?

Changes made in the transaction are immediately visible inside the
transaction. Outside the transaction, the the rows are locked.

Perhaps you could dump the data into a temp table before you delete it.

David

 

[Neven Klofutar]

OK, thanx.

Neven

Changes made in the transaction are immediately visible inside the
transaction. Outside the transaction, the the rows are locked.

Perhaps you could dump the data into a temp table before you delete it.

David

 

[prabhupr]

if this does not work, look into SQL Triggers and within that look for
"DELETED" table data