read exclusive locking

[Peter Bateman]

Hi Stephen:
 
 
        There is good discussion on SERIALIZABLE isolation level. at http://www.oracle.com/technology/oramag/oracle/05-nov/o65asktom.html
        I have used the SELECT ... FOR UPDATE syntax in a PowerHouse cursor.
        This will prevent someone else from updating what you read.
Regards,
Peter


From: shulbert at clblf.comTo: powerh-l at lists.sowder.comSubject: read exclusive lockingDate: Wed, 9 Apr 2008 14:34:02 +0100




I need to implement a serializable locking strategy at record level in 8.41D1 Quick against an Oracle 9i back end.
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.
The Quick manual says Powerhouse can do this but I haven't been able to make it work.
Does anyone have a simple example of this?
Many thanks,
Stephen.


-- 
Stephen HulbertSenior Analyst ProgrammerFor and on behalf ofCLB Littlejohn Frazer
Direct: 020 7369 4501



CLB Littlejohn FrazerChartered Accountants1 Park PlaceCanary WharfLondonE14 4HJTel 020 7987 5030Fax 020 7987 9707www.clblf.comThe information contained in this communication is confidential and may belegally privileged.  It is intended solely for the use of the individual orentity to whom it is addressed and others authorised to receive it.  If youare not the intended recipient you are hereby notified that any disclosure,copying, distribution or taking of any action in reliance on the contents ofthis information is strictly prohibited and may be unlawful.CLB Littlejohn Frazer reserves the right to monitor the content of anymessage sent to or from clblf.com.A list of partners may be inspected at the above address which is also theaddress for serving documents.CLB Littlejohn Frazer is registered to carry on audit work by the Instituteof Chartered Accountants in England & Wales, and authorised and regulated bythe Financial Services Authority for investment business.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. Littlejohn Advisors LLP is registered as a Limited Liability Partnership in England and Wales No. OC331599. Registered office as above.
_________________________________________________________________
Try Chicktionary, a game that tests how many words you can form from the letters given. Find this and more puzzles at Live Search Games!
http://g.msn.ca/ca55/207
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20080409/edd857a2/attachment.html