<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
FONT-SIZE: 10pt;
FONT-FAMILY:Tahoma
}
</style>
</head>
<body class='hmmessage'>
Hi Stephen:<BR>
<BR>
<BR>
There is good discussion on <SPAN class=bodycopy>SERIALIZABLE isolation level. at <A href="http://www.oracle.com/technology/oramag/oracle/05-nov/o65asktom.html">http://www.oracle.com/technology/oramag/oracle/05-nov/o65asktom.html</A></SPAN><BR>
<SPAN class=bodycopy> I have used the <SPAN class=boldbodycopy>SELECT ... FOR UPDATE</SPAN><SPAN class=bodycopy> syntax in a PowerHouse cursor.</SPAN></SPAN><BR>
<SPAN class=bodycopy><SPAN class=bodycopy> This will prevent someone else from updating what you read.</SPAN></SPAN><BR>
<SPAN class=bodycopy><SPAN class=bodycopy>Regards,</SPAN></SPAN><BR>
<SPAN class=bodycopy><SPAN class=bodycopy>Peter</SPAN></SPAN><BR>
<BLOCKQUOTE>
<HR>
From: shulbert@clblf.com<BR>To: powerh-l@lists.sowder.com<BR>Subject: read exclusive locking<BR>Date: Wed, 9 Apr 2008 14:34:02 +0100<BR><BR>
<META content="Microsoft SafeHTML" name=Generator>
<STYLE>
.ExternalClass p.EC_MsoNormal, .ExternalClass li.EC_MsoNormal, .ExternalClass div.EC_MsoNormal
{margin-bottom:.0001pt;font-size:11.5pt;font-family:'Book Antiqua';}
.ExternalClass p.EC_MsoHeader, .ExternalClass li.EC_MsoHeader, .ExternalClass div.EC_MsoHeader
{margin-bottom:.0001pt;font-size:11.5pt;font-family:'Book Antiqua';}
.ExternalClass p.EC_MsoFooter, .ExternalClass li.EC_MsoFooter, .ExternalClass div.EC_MsoFooter
{margin-bottom:.0001pt;font-size:11.5pt;font-family:'Book Antiqua';}
.ExternalClass a:link, .ExternalClass span.EC_MsoHyperlink
{color:blue;text-decoration:underline;}
.ExternalClass a:visited, .ExternalClass span.EC_MsoHyperlinkFollowed
{color:#606420;text-decoration:underline;}
.ExternalClass p.EC_MsoPlainText, .ExternalClass li.EC_MsoPlainText, .ExternalClass div.EC_MsoPlainText
{margin-bottom:.0001pt;font-size:10.0pt;font-family:'Courier New';}
.ExternalClass p
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;font-family:'Times New Roman';}
.ExternalClass p.EC_Bullets, .ExternalClass li.EC_Bullets, .ExternalClass div.EC_Bullets
{margin-right:0cm;margin-bottom:12.0pt;margin-left:50.4pt;text-indent:-14.4pt;font-size:11.5pt;font-family:'Book Antiqua';}
.ExternalClass p.EC_Numbering, .ExternalClass li.EC_Numbering, .ExternalClass div.EC_Numbering
{margin-right:0cm;margin-bottom:12.0pt;margin-left:14.4pt;text-indent:-14.4pt;font-size:11.5pt;font-family:'Book Antiqua';}
.ExternalClass span.EC_EmailStyle20
{font-family:Arial;color:windowtext;}
.ExternalClass span.EC_EmailStyle21
{font-family:Arial;color:windowtext;}
.ExternalClass span.EC_EmailStyle25
{font-family:Arial;color:windowtext;}
@page
{;}
@page Section1
{size:595.45pt 841.7pt;}
.ExternalClass div.EC_Section1
{page:Section1;}
</STYLE>
<DIV class=EC_Section1>
<P class=EC_MsoNormal><FONT face="Book Antiqua" size=3><SPAN style="FONT-SIZE: 11.5pt">I need to implement a serializable locking strategy at record level in 8.41D1 Quick against an Oracle 9i back end.</SPAN></FONT></P>
<P class=EC_MsoNormal><FONT face="Book Antiqua" size=3><SPAN style="FONT-SIZE: 11.5pt">That is, the records read by the screen are locked exclusively and other users will have to wait until the lock is released to read them.</SPAN></FONT></P>
<P class=EC_MsoNormal><FONT face="Book Antiqua" size=3><SPAN style="FONT-SIZE: 11.5pt">The Quick manual says Powerhouse can do this but I haven't been able to make it work.</SPAN></FONT></P>
<P class=EC_MsoNormal><FONT face="Book Antiqua" size=3><SPAN style="FONT-SIZE: 11.5pt">Does anyone have a simple example of this?</SPAN></FONT></P>
<P class=EC_MsoNormal><FONT face="Book Antiqua" size=3><SPAN style="FONT-SIZE: 11.5pt">Many thanks,</SPAN></FONT></P>
<P class=EC_MsoNormal><FONT face="Book Antiqua" size=3><SPAN style="FONT-SIZE: 11.5pt">Stephen.</SPAN></FONT></P>
<DIV>
<DIV>
<FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">-- </SPAN></FONT><BR>
<FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">Stephen Hulbert<BR>Senior Analyst Programmer<BR>For and on behalf of<BR>CLB Littlejohn Frazer</SPAN></FONT><BR></DIV></DIV>
<FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">Direct: 020 7369 4501</SPAN></FONT><BR></DIV><BR><BR>
<TABLE style="COLOR: black" bgColor=white>
<TBODY>
<TR>
<TD><BR>CLB Littlejohn Frazer<BR>Chartered Accountants<BR>1 Park Place<BR>Canary Wharf<BR>London<BR>E14 4HJ<BR><BR>Tel 020 7987 5030<BR>Fax 020 7987 9707<BR>www.clblf.com<BR><BR>The information contained in this communication is confidential and may be<BR>legally privileged. It is intended solely for the use of the individual or<BR>entity to whom it is addressed and others authorised to receive it. If you<BR>are not the intended recipient you are hereby notified that any disclosure,<BR>copying, distribution or taking of any action in reliance on the contents of<BR>this information is strictly prohibited and may be unlawful.<BR><BR>CLB Littlejohn Frazer reserves the right to monitor the content of any<BR>message sent to or from clblf.com.<BR><BR>A list of partners may be inspected at the above address which is also the<BR>address for serving documents.<BR><BR>CLB Littlejohn Frazer is registered to carry on audit work by the Institute<BR>of Chartered Accountants in England & Wales, and authorised and regulated by<BR>the Financial Services Authority for investment business.<BR><BR>CLB Corporate Finance LLP is registered as a Limited Liability Partnership in England and Wales ; No. OC300623. Registered office as above. CLB Corporate Finance LLP is authorised and regulated by the Financial Services Authority. <BR><BR>Littlejohn Advisors LLP is registered as a Limited Liability Partnership in England and Wales No. OC331599. Registered office as above.<BR></TD></TR></TBODY></TABLE></BLOCKQUOTE><br /><hr />Sign in today. When you sign in to Windows Live Messenger you could win $1000 a day until May 12th. <a href='http://g.msn.ca/ca55/209' target='_new'>Learn more at SignInAndWIN.ca</a></body>
</html>