Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Locking and Transactions
- Thread starter itflash
- Start date
- Status
When a transaction starts with 'BEGIN TRANSACTION', this shall be ended with 'END TRANACTION' or a 'ROLLBACK'.
The records rewritten or deleted or added (processed) will not be available to any other user and so locking the very same records is not possible by other users. SO make sure that the begin.. end transaction loop is as small a time as possible and never allow any user interaction between the loop. This will help in safeguarding the data base and also not closing the gates for other users.
Hope this helps ramani :-9
(Subramanian.G)
FoxAcc
ramani_g@yahoo.com
LET KNOW IF THIS HELPED. ENOUGH EXPERTS ARE HERE TO HELP YOU OUT! BEST OF LUCK
The records rewritten or deleted or added (processed) will not be available to any other user and so locking the very same records is not possible by other users. SO make sure that the begin.. end transaction loop is as small a time as possible and never allow any user interaction between the loop. This will help in safeguarding the data base and also not closing the gates for other users.
Hope this helps ramani :-9
(Subramanian.G)
FoxAcc
ramani_g@yahoo.com
LET KNOW IF THIS HELPED. ENOUGH EXPERTS ARE HERE TO HELP YOU OUT! BEST OF LUCK
- Status
Similar threads
