"STRANGE" BEHAIVIOR

Mon, 1 Mar 1999 12:51:52 +1100

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_000_01BE6386.71A663D0
Content-Type: text/plain;
	charset="iso-8859-1"

Hi Bob, Allison.

Thanks a lot for your ideas.

Bob, I was very careful about closing the file everywhere it was
appropriate.

Allison, I am dealing with fixed length records.

I was thinking about it all weekend and I finally come up with a simple
solution.

The problem was as I suspected.

When my designer procedure hit an error, it was in the middle of a while
retrieving loop reading records from my temporary file. It has just
successfully read a record and set the file buffer flags accordingly. Now,
before flagging the error, I close the file. I thought that this action
would reset any buffer flags, set by the previous successful read. But it
appears that it does not. So, when I create my new temporary file, and try
to write a new record to this empty file, because the buffer flags still
contain the values from the last successful read of the file, PH thinks that
I am trying to change/update previously read record and gives me the error
"record has changed since you last found it".

The solution I came up with is prior to the first write, I do a get <file>
optional. Now, since my new file is empty at this time, I get an
unsuccessful read, which resets the buffer flags appropriately, so that when
I try to write, PH sees this correctly as writing a new record.

This was really a curly one.

Regards and thanks again,

Arthur Kogan
Westpac Financial Services
Sydney, Australia

> -----Original Message-----
> From:	Hamilton, Allison [SMTP:Allison.Hamilton@Cognos.COM]
> Sent:	Saturday, 27 February 1999 1:48 AM
> To:	Deskin, Bob; 'Arthur Kogan'
> Cc:	'powerh-l@lists.swau.edu'
> Subject:	RE: "STRANGE" BEHAIVIOR
> 
> Arthur - is your temporary file variable length, perchance???  If so, I
> suspect that the problem may be due to a couple of variable length record
> issues we've found lately with both PH 8 and 7 versions in similar
> scenarios.  These problems should be corrected to the best of our
> knowledge
> in 710G2.  (251425, 248103 are related problems - your scenario is similar
> to 248103 - except that it was with mailboxes, but a mailbox is just a
> variable length virtual file - in this case also, the scenario worked
> every
> other time, the problem happens when you go from a shorter length record
> to
> a longer record)
> 
> Hope that helps.
> Allison Hamilton
> 
> > ----------
> > From: 	Arthur Kogan[SMTP:akogan@westpac.com.au]
> > Sent: 	Friday, February 26, 1999 1:40 AM
> > To: 	Deskin, Bob
> > Cc: 	'powerh-l@lists.swau.edu'
> > Subject: 	"STRANGE" BEHAIVIOR
> > 
> > Hi Bob,
> > 
> > I think this one requires your "deep" knowledge of PH to explain.
> > 
> > I am working on a quite complex screen and have hit a problem, which I
> can
> > not
> > readily explain (which is concerning in it self!!!). I am using PH710F4
> on
> > Alpha VMS with RMS files.
> > 
> > In my screen after "finding" a primary record, I run a designer
> procedure.
> > The
> > designer procedure:
> > 
> > 1. sets a system variable with the name of my temporary data file, using
> > setsystemvalue function.
> > 2. runs command to create the empty file, using "create/fdl=..."
> command.
> > This
> > is an indexed RMS file.
> > 3. writes some records to this file, using "put <filename> reset". It
> > writes
> > new records only.
> > 4. reads this file during further processing and displays some values on
> > the
> > screen.
> > 5. closes the temporary file.
> > 
> > I have been careful to put close file statement just before flagging any
> > error
> > messages occurring after the first write to the file, within this
> designer
> > procedure, as in this case the execution of the procedure stops at the
> > error
> > message and does not continue to step 5.
> > 
> > The problem occurs when after running the designer procedure once, I run
> > it
> > again without re-finding the primary record or updating (if I do either
> of
> > those, there is no problem). The original error message I was receiving
> > was an
> > RMS error about "bucket format check failed". After digging dipper, I
> got
> > the
> > Powerhouse error "record has changed since you last found it" on the
> first
> > write to the new temporary file.
> > 
> > This has got me thinking, that although I am trying to write "new"
> records
> > to
> > the "new" empty file, because I have not done a find or update, PH
> thinks
> > that
> > I am writing an updated version of the last read record. To test this, I
> > changed my "put <filename> reset" command to "put NEW <filename> reset".
> > This
> > time I got no error, but NO records were written to the file. Note also
> > that
> > the error only occurs every second time, i.e. if after finding the
> primary
> > record, I run the designer procedure 6 times, the error will occur only
> > the
> > second, fourth and sixth time.
> > 
> > Now, I think I can guess that the problem here is that the record status
> > flag
> > does not get reset, so the screen thinks I want to update instead of
> > adding a
> > new record. The question is how can I force this to happen? If I can not
> > get
> > this to work this way, I guess, I can change the screen to run the
> > designer
> > procedure from POSTFIND, so it can only be run after the user does a
> find,
> > but
> > I would really like to get this to work according to the original
> design.
> > 
> > Please help/explain/confirm my guess.
> > 
> > Regards,
> > 
> > Arthur Kogan
> > Westpac Financial Services
> > Sydney, Australia
> > 
> > = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> =
> > =
> > 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.
> > 

------_=_NextPart_000_01BE6386.71A663D0
Content-Type: application/ms-tnef
Content-Transfer-Encoding: base64

eJ8+IiABAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQSAAQAYAAAAUkU6ICJTVFJBTkdFIiBCRUhBSVZJT1IAAgYBCYAB
ACEAAABEQkI1RUYwNzZFQ0ZEMjExODgzRTAwMDA4MzY4MzU2NwAhBwEggAMADgAAAM8HAwABAAwA
NgAdAAEAOgEBBYADAA4AAADPBwMAAQAMADMANAABAE4BAQ2ABAACAAAAAgACAAEDkAYAuBEAACsA
AAALAAIAAQAAAAMALgAAAAAAQAA5AMBtRhSGY74BHgBwAAEAAAAUAAAAIlNUUkFOR0UiIEJFSEFJ
VklPUgACAXEAAQAAABsAAAABvmGXDyrLLj/TzVAR0p4ZAAD2uPoRAHs+mZAAAgEJEAEAAADKDAAA
xgwAABwaAABMWkZ1ai5VWwMACgByY3BnMTI10jIA+zM2AeggAqQD4wkCAGNoCsBzZXQwHiAHEwKD
AFAQVnBycd4yEVkOUAPVEWV9CoAIyOwgOwlvDjA1FX8KYAKA2QqBdWMAUAsDYwBBC2Aibg4QMDMz
C6YgSEBpIEJvYiwRUGx2bAQAAiAuCqIKhAqAVMkQ4G5rBCBhIAkABUBLAhAFwHkIYSBpAQBhRnMb
GxpTSSB3HXAgYnYEkHkgYwrAARB17wMgAaAIYAVAYwkAAJAZMHAgdGhlHKADECDgZX0fEncg0Bbg
HTAFQB7SYZpwEqBvEqAHMHRlGxvjGqUekmFtIB1RGsAgkXcD8CDAIPF4CYAcYAnwZ/clcRbgBaFk
HYwetCDAC4C+ayCCH+QiAQdAAyB3CeB+awnwJeAAcCXgHrAhAG7PKTEfQQNwIOB1cCVEHFA9AJBt
C1Ag4BrgCkB0ae8a/yDgIpECYGUksCIzBCBhHrBzdXNwBZAjAGTtGxtXINADoG0fQAEAAJDsZ24E
kC2yYwmACHAg4N8oICkRA6AEkANgchqAIgUrC4Ags20dQGQhIW9mrxxBIaAhEhbgdAiBdiCC5wkA
IrAmYWFkIIImdRyg/wNhMHIjACvgBbAKwB9AIQLeLh6gBUAQ4AQgai7gBUD9LtBjMXAEEB+hKqE1
whxBzyZ0KeMRESC4YnUBIDER+mYLYGccMTkgJqEggSqg0TggTm93GoBiARAFsPsg4TxBZyCGMlUe
sCBCIODPIMY4ISCxCGBnaDsSIvDfKAI8cixyHsAIYGwl4BbgvzryAHAfQDvKGoA68mI3IX8tkzUR
CGAEIDkINbM4IEI/KNUigB1gEQBBFCIBZG/NB5FuHIA4IFNvGoAhof8DoD9hNcEjADByMQAH4DdM
7xqAKfI04Dchbx7ABRBJYb8cUEnCOkVLgUFzN1F0Sob/PbAfYC7gP8Q7yzjQAxADIO8FoAIwC3Eg
s3YHQApQNqV/IMILYDjbOcQ0ESDGGoBQ/kgoBEc1JINLQSCDS5AQ0ekZMGUvKyBkSVJExjmmPzpJ
PmAfEAQgKvE+tyAi/zpFOHJV1DrRC4AxcBziUcTtAhB1KcEiACIsvyw2P1L/JKArCEGRIsEFsUzj
IOIRAH8iEUvCHpJH0BxBVhAFQDz9IQI+NAAFMCyBB0A9RVrU/0mVIQNNN0FGLHAHgB6SYSL/A5Fb
4EVdSJIN4CZSEREn8v87riKIKqBD8UzyQUFItUtKv1PTERAHkUFzBaEmcXQqof8e4UuyKGNMKRsd
QZEe0jXBeyqSHFBjCHAqoQIgIxxS/GVnCxEcMUsSG/VyAAuAliwjOwAgaB0RS29yABcLkC/kB5B0
CrBjIEb/KmFa8AcxBlI1IDkxGyQGsHZkMQBpsUE4wTeQGsBh/RskIArjG2YK9BrADzEYwR8BQCKR
IwAvIBHkMTYgui17ok8FED5hdkFNOUH9PFBle6MbJnq0eoELE3q2YGktMTQ0AUAawDHcODABQAzQ
f0NidcADYfo6DINiGgEkoAMQS4AkUQEapSBbU01UUDo7GqaBZkAIUDDwIGAuQ/hPTV0bJYBwBmAC
MIDXnQYQdAhwVmBpsTI3dcCQZWJydTeiMTmHcFGHUDo0OBFQTYSnVHpvgNdEB5AoURqAGlE7lCAn
dDonhKdDY4DXBic3cClwcmgtbEDbGsFnsC4D4E5QLjGBiwgwU3Viai8RgNdSRQI6WYBTVFJBTkcE
RSIaQEVIQUlW+ElPUn1Pflp6BhORE5L7DAFz6i1e0hzzN0xQwQchby3xJfUagC8AclXSMXA/+5fA
eMBJNCAa4B6RGyQu1f9BFi2oAMBDESDgMZA/wWDi/wWgKyAz5JYtJmUbJAQBUQL9KXAnHxBbtQtg
aYIlRAbg/yVxU/GH4CnyhrAfEQCQAiD/MxMrwQMQCsCYlTFwKnBfIf8dgHjALYE/sS3FRTFAsUJh
/5rBbIUl0V91PbA40TQRHQLqa0ggdyEgZFYQnYUDoNI3GVBHMqLxKA4wf0D/DjCGgYfQGVEcQCHR
FuCfEv8l4KOHlJAc86JmXtKhm0uB86i1lJBleDFwBTFHVh7S/yVTAMADEAbgJcBD4TvAKRH/rqZe
0jizeFWcLjUgACCHEH8DICEDlJEzQmxSHXBL8WzvmEIgwqrnQjByKaAl4CFT/xskn+ExEWT0mcoQ
4EbhBjH7SLNbMmdLkDbDK6FAsAAg/zERJgtLcRskHFJWAQXAJnR6KRsqSCKwP8JBQSDQbP5wHYaC
BoFmGyphsHujfPl/YbCAkwMwAZERUXRYgoRhWmt0skApcHVzLirRLv9OUISVYbCFM8HEgJAdQIZi
+YbXMjYagIdmEUGIFWGw/4ixwcSJab/Wi6HBxIxfjWz/xQGOhcHEj7+QxmGwv9YaJT/O3kCCKDFB
ZHDhJmFxdfdf8AeRHPMiAQCtYM4gpof/NAJT8kuQrTALUxsV0Kokof+1IiCCQgEcUNJxSWEq0Svx
/7AgBPEJ4SnjEOCegTHjLbb/ZvZd8nTlYbBIIb/WNcMqof/U1agQZxRsU1rxBKAggjMxoyIBERBs
ZiHfEClAYp8koS7gIIJT8KehRjRw0cu/1hqgcBDgIFYF4SVT/lIF4SECHYbQqTBj2FYBgP0xESIq
UTXyziDZkgdwN6L/JnQekocA1zIwvyMWyEEg0Nu/1udPZYDQzu0xOCBnk/0roXk40C4RliclUyDC
KnD/KvE0ETcbVmEcUEqk38O/1v9nkuyDUNMcoFvgQdPix6fh++bhbGJtA4FMw0klPrNNeRXfxCJJ
JC8FcGw9Lv/2kM4g81XoaQQAv9ZBkt6B3ynArTAl0eI24sczOCBLs99FMSriNkZM5vUbcCARYWP/
7gLcAhERXEA4Mb/W+sTa9+9MR9HyPSG/1jTy4TXRbBX/IQMxkSCCH6CUMTEWEJAoY/8pwTXwLvAL
YOyA+yRQ1eCo7yDB8FfYY+LHNTggP4NnxP83TeLf2PQ9sDBRH2ZLgf1S/z+EIQM40CLx7iAPoDik
Pb7/QvG/1jJTv9buIHyj0fE5IP8DEAMj5KRfrV9oSsLh4rMm/+mmv9YxR0rhMxWzdj6zJcD/cIBB
41MlMUg40CKwHDE7E/8PzxDZBJRH5VADfDCbBOyR/yswCHDO3i2KEaO4JeSk5uH/3iNTUumvM/Fa
8eal+Cfbl+9zE16DKMLkUC3lFUR15erPNAA8EFZDVWIoaTQgYLP+ZV6hMRE0EAZYP6G0M6kx/0GR
SCAttt9BLYJfQHwVWTT/G+ZU4G+0MXBYcPApriLa2K/iMlk0i/AloiI7wGO1UP1bonKvwB0RU2Ax
IFuwrsH70/D+kUHkszXwPlQ18Ebh7z8zuNDblwbZUMrTRRFZH/9aL1s/ziBCAV+n/utfZknP/wov
99M3MzRRWLRUQVVhtDJ3QUF4ICWCZ9qCVQtLtCL/O6HOIACFNIe65QazQZVNb/+zwQtFHPJH0NIh
74IEsSfG/1PKNIj2ENXcbWZlwVZTUwD/oNVTFlHTV2kr0fwRpdICYv+YZ2GwN4ZjIf1P/lPzSk8T
+E5FV09fXEb3zGTyNCTnKxIbE69ETk8Ad8rh7VH/E1HXoLMxE7hiUtehs/JIL/9DZTZkAQIgFrWT
6/EdMbqx/WUDaY2Q/qAokeSkJh+1xv/cAuZqIc8i1HuAZPKvMVnY/+HgcCARlADzNI/wsluyd7Dv
nrGUMQSTYDB47ZJcETzP/VgAdzQS0WTao7jABfFsEv+ZnSqmaQc21Q2isIC/1g8C/+knHLam8CXC
7AF3sIMgtEX/5FNHxC2TDhFRAUcU3mHskf9MQSmITEAmQ3hVACor1NJw/3VhSyI98srQaFNAUA6x
ODH/AmNRAbfEl+CYEWhE23ltwf9jaHXUtSICVK4gxiFUcWiy/zQSaGJOZG6b/BBflekuFb8JuPRQ
T82wRklORP9uU63xaGJac5rB5uMSVzYh/zMRHLJGdNA3VXHQyLUgpEL/AgG+gIdAy1C1UPvybcJ4
q3/EADbyQNUT0iw3YBRmb1DXnICzsr2yL9TVLx0xOgHPmmHGwGijiJ9SZcNwAMH30D/CKr/WV8PE
xcAscTggd5xQLKDFIHIuUAQhxKd59mQiUMYhQbCBPDDLUHJn/b/WPZPflO+V/5cPl1KTZ9vMSdhR
aaXAzTAingCZpb8rQMrVziDc8Rvmn9Bk7pHbQwevwGoAsftAb8tNv9b+VfMgmZnzEZpfm2tRAZ0v
/549ys/L1Ktiw3DXoHnBqbGt0hEtecH78mKt8C7LU/2Q4S6kRj1by1Ldgwiy5pH/wkH74zwQTUI7
RMtSyVC4kq5tDlTsQpmWcovtfbswAgCusAAAAwD9P1IDAAAeAEIQAQAAAD8AAAA8NDMwRjg4N0Q0
MTVERDExMThDMjcwMDgwNUYzMUVDRjEwMTBFMDkwQkBzb3RhMDAwNS5jb2dub3MuY29tPgAACwAA
gAggBgAAAAAAwAAAAAAAAEYAAAAAA4UAAAAAAAADAAeACCAGAAAAAADAAAAAAAAARgAAAAAQhQAA
AAAAAAMAI4AIIAYAAAAAAMAAAAAAAABGAAAAAFKFAAB0EAAAHgAkgAggBgAAAAAAwAAAAAAAAEYA
AAAAVIUAAAEAAAAFAAAAOC4wMgAAAAADAA+ACCAGAAAAAADAAAAAAAAARgAAAAABhQAAAAAAAAsA
KYAIIAYAAAAAAMAAAAAAAABGAAAAAA6FAAAAAAAAAwAMgAggBgAAAAAAwAAAAAAAAEYAAAAAEYUA
AAAAAAADACuACCAGAAAAAADAAAAAAAAARgAAAAAYhQAAAAAAAB4AOoAIIAYAAAAAAMAAAAAAAABG
AAAAADaFAAABAAAAAQAAAAAAAAAeADuACCAGAAAAAADAAAAAAAAARgAAAAA3hQAAAQAAAAEAAAAA
AAAAHgA8gAggBgAAAAAAwAAAAAAAAEYAAAAAOIUAAAEAAAABAAAAAAAAAAMAJgAAAAAAAwA2AAAA
AAAeADFAAQAAAA8AAABLT0dBTkE0RENCNzgzOAAAAwAaQAAAAAAeADBAAQAAAA8AAABLT0dBTkE0
RENCNzgzOAAAAwAZQAAAAAADAIAQ/////wIB+T8BAAAAYgAAAAAAAADcp0DIwEIQGrS5CAArL+GC
AQAAAAYAAAAvTz1XRVNUUEFDL09VPVdCQy9DTj1SRUNJUElFTlRTL0NOPU1TTUFJTCBBRERSRVNT
RVMvQ049S09HQU5BNERDQjc4MzgAAAAeAPg/AQAAAA4AAABLb2dhbiwgQXJ0aHVyAAAAHgA4QAEA
AAAPAAAAS09HQU5BNERDQjc4MzgAAAIB+z8BAAAAYgAAAAAAAADcp0DIwEIQGrS5CAArL+GCAQAA
AAYAAAAvTz1XRVNUUEFDL09VPVdCQy9DTj1SRUNJUElFTlRTL0NOPU1TTUFJTCBBRERSRVNTRVMv
Q049S09HQU5BNERDQjc4MzgAAAAeAPo/AQAAAA4AAABLb2dhbiwgQXJ0aHVyAAAAHgA5QAEAAAAP
AAAAS09HQU5BNERDQjc4MzgAAEAABzAQRo8JhGO+AUAACDDQY6ZxhmO+AR4APQABAAAABQAAAFJF
OiAAAAAAHgAdDgEAAAAUAAAAIlNUUkFOR0UiIEJFSEFJVklPUgALACkAAAAAAAsAIwAAAAAAAwAG
EIQ1fAADAAcQ9hAAAAMAEBAAAAAAAwAREAMAAAAeAAgQAQAAAGUAAABISUJPQixBTExJU09OVEhB
TktTQUxPVEZPUllPVVJJREVBU0JPQixJV0FTVkVSWUNBUkVGVUxBQk9VVENMT1NJTkdUSEVGSUxF
RVZFUllXSEVSRUlUV0FTQVBQUk9QUklBVEVBAAAAAFsU

------_=_NextPart_000_01BE6386.71A663D0--
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.