Re: Updating a table and row locking.
- From: daniel.benjamin.e@xxxxxxxxx
- Date: 28 Mar 2007 13:46:45 -0700
I am using an Access database and the field is a Memo field. I do a
replace on apostrophes to avoid any SQL syntax issues and do an
"Update FieldName set XMLFieldName = 'XMLDOCVALUE' where ID = N"
I do an update on the table twice, the sql seen above is from the
second update. As mentioned in the first post to this message, I
wanted to simplify my XML parsing code so I divided the update
statement. The question remains: How do I release the locks on my
database once I'm done?
On Mar 28, 1:46 pm, "Stephen Howe" <stephenPOINThoweATtns-
globalPOINTcom> wrote:
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
.
- References:
- Updating a table and row locking.
- From: daniel . benjamin . e
- Re: Updating a table and row locking.
- From: Stephen Howe
- Updating a table and row locking.
- Prev by Date: Re: Updating a table and row locking.
- Next by Date: VB6 ADO connection SQL Express 2005 SP2 - severe lag with network connection enabled
- Previous by thread: Re: Updating a table and row locking.
- Next by thread: VB6 ADO connection SQL Express 2005 SP2 - severe lag with network connection enabled
- Index(es):
Relevant Pages
|
|
