Re: Updating a table and row locking.
- From: "Stephen Howe" <stephenPOINThoweATtns-globalPOINTcom>
- Date: Wed, 28 Mar 2007 18:46:26 +0100
Anyway, one of the problems with my solution is that the row gets
locked and I get errors when the second SQL statement is called. My
fix is a looped try catch block (I'm working in jscript here) that
keeps trying until the data goes in. This works, but it is kind of
slow. Any ideas on how to release the locks. CommitTrans() does not
do the job. Can I specify a very short timeout period when I
establish my connection (timeout for keeping the row locked)?
What database?
And how are puttuing the XML into the database?
Stephen Howe
.
- Follow-Ups:
- Re: Updating a table and row locking.
- From: daniel . benjamin . e
- Re: Updating a table and row locking.
- References:
- Updating a table and row locking.
- From: daniel . benjamin . e
- Updating a table and row locking.
- Prev by Date: Re: WHILE LOOP NOT WORKING IN INCLUDE ASP FILE - LOOPING FOREVER
- Next by Date: Re: Updating a table and row locking.
- Previous by thread: Updating a table and row locking.
- Next by thread: Re: Updating a table and row locking.
- Index(es):
Relevant Pages
|
|
