Transaction Optimistic???

[Ronald W. Olenic]

This is a multi-part message in MIME format.
--------------8788BFBA820DCE4C7C74E43E
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hi Mark!

It sounds as though the default commit point has been changed from mode
to screen.  

Make a change in session one and do an update stay.  Then try to
retrieve the changed data in session two.  If session two can't see the
changed data, but session one can, then the transaction has not been
committed.  Session two would still be able to change the orignal data,
but session one would get a record has changed since you found it as you
exited the screen.  If you are doing a refresh on the calling screen,
you may not even see the message.

Then again, it may be the VMS elves...

Ron Olenic
The views expressed are my own and do not necessarily reflect those of
any other sentient being.



stewm@canada.com wrote:
> 
> Got hit by an 18 wheel transfer truck last night heading back to the client site but I lived another day to post to the PowerHouse listserv.  My poor Mustang is in pretty bad shape though.  Truck drivers think they own the road!
> Anyway, I have a screen I'm working on that had locking problems.  After passing parameters instead of the file to a receiving master and changing the TRANSACTION model to concurreny I has able to get rid of the locking.  The transaction model before was optimistic. I ran three sessions with the same record open on each and performed an update.  Why am I not getting the 'Data has changed since you found it.' phrase.  The transaction model seemed to be the determining factor in ridding the screen of locks but now users updates can override another's even when they did a find before the other updated.  7.10 Vax/VMS/Rdb.  What's the deal?  I should be getting the 'Data has changed since you found it.' message shouldn't I?
> 
> Mark Stewart
> Windsor, Ontario
> Canada
> 
> ----------------------------------------------------------
> Get your FREE personalized e-mail at http://www.canada.com
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
> Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
> powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
> This list is closed, thus to post to the list, you must be a subscriber.
--------------8788BFBA820DCE4C7C74E43E
Content-Type: text/x-vcard; charset=us-ascii;
 name="olenicr.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Ronald W. Olenic
Content-Disposition: attachment;
 filename="olenicr.vcf"

begin:vcard 
n:Olenic;Ronald
x-mozilla-html:TRUE
org:Compuware
adr:;;;;;;
version:2.1
email;internet:ronolenic@bigfoot.com
title:Senior Systems Analyst
note;quoted-printable:The opinions expressed are my own, and as such are subject to change or  even complete reversal without notice=0D=0A
fn:Ronald Olenic
end:vcard

--------------8788BFBA820DCE4C7C74E43E--

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.