Select for update
[prev]
[thread]
[next]
[Date index for 2004/07/19]
This is a multi-part message in MIME format.
------_=_NextPart_001_01C46D92.812E3D70
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Hi,
I'd like to make some of my units of work (collections of updates across
multiple tables) atomic, and plan to do this by issuing "select ... for
update" commands instead of simple selects.
Am I right to think I need to overload private methods or use add_sql
for this?
Thanks,
Ian
--
Dr Ian McDonald
Software Engineer, Interactive Drama & Entertainment
Conquer the Earth! - The Doctor Who monsters game
The Rome Game: Do as the Romans do. Lie, cheat, and steal.
A300, 56-58 Wood Lane (CH), London W12 7SB
020 822 56162
ian.mcdonald@xxx.xx.xx / "Ian McDonald-ONLINE" (not "Ian MacDonald")
http://www.bbc.co.uk/ - World Wide Wonderland
This e-mail (and any attachments) is confidential and may contain
personal views which are not the views of the BBC unless specifically
stated.
If you have received it in error, please delete it from your system.=20
Do not use, copy or disclose the information in any way nor act in
reliance on it and notify the sender immediately. Please note that the
BBC monitors e-mails sent or received.=20
Further communication will signify your consent to this.
------_=_NextPart_001_01C46D92.812E3D70
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; charset=3Dus-asci=
i">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version 6.0.6503.0=
">
<TITLE>Select for update</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT SIZE=3D2 FACE=3D"Arial">Hi,</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">I'd like to make some of my units of wor=
k (collections of updates across multiple tables) atomic, and plan to do =
this by issuing "select … for update" commands instead of=
simple selects.</FONT></P>
<P><FONT SIZE=3D2 FACE=3D"Arial">Am I right to think I need to overload p=
rivate methods or use add_sql for this?</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">Thanks,</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">Ian</FONT>
</P>
<P><FONT COLOR=3D"#808080" SIZE=3D1 FACE=3D"Arial">--</FONT>
<BR><FONT COLOR=3D"#808080" SIZE=3D1 FACE=3D"Arial">Dr Ian McDonald</FONT=
>
<BR><FONT COLOR=3D"#808080" SIZE=3D1 FACE=3D"Arial">Software Engineer, In=
teractive Drama & Entertainment</FONT>
<BR><FONT COLOR=3D"#808080" SIZE=3D1 FACE=3D"Arial">Conquer the Earth! - =
The Doctor Who monsters game</FONT>
<BR><FONT COLOR=3D"#808080" SIZE=3D1 FACE=3D"Arial">The Rome Game: Do as =
the Romans do. Lie, cheat, and steal.</FONT>
<BR><FONT COLOR=3D"#808080" SIZE=3D1 FACE=3D"Arial">A300, 56-58 Wood Lane=
(CH), London W12 7SB</FONT>
<BR><FONT COLOR=3D"#808080" SIZE=3D1 FACE=3D"Arial">020 822 56162</FONT>
<BR><FONT COLOR=3D"#808080" SIZE=3D1 FACE=3D"Arial">ian.mcdonald@xxx.xx.x=
k / "Ian McDonald-ONLINE" (not "Ian MacDonald")</FONT=
>
</P>
<BR>
<br>http://www.bbc.co.uk/ - World Wide Wonderland<br><br>This e-mail (and=
any attachments) is confidential and may contain<br>personal views which=
are not the views of the BBC unless specifically<br>stated.<br>If you ha=
ve received it in error, please delete it from your system. <br>Do not us=
e, copy or disclose the information in any way nor act in<br>reliance on =
it and notify the sender immediately. Please note that the<br>BBC monitor=
s e-mails sent or received. <br>Further communication will signify your c=
onsent to this.</BODY>
</HTML>=
------_=_NextPart_001_01C46D92.812E3D70--
 |
Select for update
Ian McDonald-ONLINE 13:15 on 19 Jul 2004
|
