Re: insert into problem

Article View: borland.public.interbase.sql

Article #142

Back to borland.public.interbase.sql Previous Next

#142

From: Bill Todd [TeamB]
Date: Mon, 09 Jun 2008 18:31

18 lines
1927 bytes

Isaac wrote:

> Ok, can you please tell me what you mean by setting one of the fields
> to itself

UPDATE ATABLE SET AFIELD = AFIELD

This does not change the value of the field but it counts as an update
so the record is locked until the transaction commits. By locking the
master record before you insert a detail record you make sure that no
other user can insert a detail record while you are inserting one
because no other user will be able to lock the master record.

Obviously you have to deal with the case where the UPDATE to the master
record fails because some other user has the record locked.

-- 
Bill Todd (TeamB)

Technical Details

Message-ID: <484d7700$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!feeder.news-service.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References:

<484b07da@newsgroups.borland.com> <484b16e4@newsgroups.borland.com> <484b52eb$1@newsgroups.borland.com> <484c007f@newsgroups.borland.com> <484c07a9$1@newsgroups.borland.com> <484c2394@newsgroups.borland.com> <484c7832$1@newsgroups.borland.com> <484d14e3$1@newsgroups.borland.com> <484d280b$1@newsgroups.borland.com> <484d2e33@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,ed255c09332ecd2c
X-Google-Attributes: gid114a0e,domainid0,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Bill Todd [TeamB]" <no@no.com>
Subject: Re: insert into problem
Newsgroups: borland.public.interbase.sql
References: <484b07da@newsgroups.borland.com> <484b16e4@newsgroups.borland.com> <484b52eb$1@newsgroups.borland.com> <484c007f@newsgroups.borland.com> <484c07a9$1@newsgroups.borland.com> <484c2394@newsgroups.borland.com> <484c7832$1@newsgroups.borland.com> <484d14e3$1@newsgroups.borland.com> <484d280b$1@newsgroups.borland.com> <484d2e33@newsgroups.borland.com>
Organization: The Database Group, Inc.
User-Agent: XanaNews/1.18.1.9
X-Face: ":yn4zt^A_dn>6~{YJmu^B\'4w)e:apPM\VC=Dvf&*tASxX9|BYczkFd$xr.$vNSZ[3Uobr p]c4\+\l){!WQI.$]veP({HLd;CDYH?iN
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: 63.147.41.232
Message-ID: <484d7700$1@newsgroups.borland.com>
Date: 9 Jun 2008 11:31:28 -0700
X-Trace: newsgroups.borland.com 1213036288 63.147.41.232 (9 Jun 2008 11:31:28 -0700)
Lines: 18
X-Authenticated-User: btodd
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!feeder.news-service.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message