<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
--></style>
</head>
<body class='hmmessage'>
Hi Martyn:<br><br>As a workaround I would put a get on the reference file in the PREUPDATE procedure.<br>This hopefully would reset the record status to OLD UNALTERED.<br><br>Is there a PUT on the reference file in the UPDATE procedure??<br><br>Regards,<br>Peter Bateman<br><br>09 09:36:36 -0800<br>> From: martyn.thomson@gov.bc.ca<br>> To: Bob.Deskin@ca.ibm.com<br>> CC: powerh-l-bounces+bob.deskin=ca.ibm.com@lists.sowder.com; powerh-l@lists.sowder.com<br>> <br>> Hi Bob.<br>> The field INSTITUTION_NAME is display only. We don't want to enter anything - just display a name. Changing PREDISPLAY to DISPLAY had no effect. <br>> It's a simple reference file lookup using a field from the primary file IF_APP_INTERNET_TMP, but it generates an ACCEPT verb in the MODIFY procedure! Adding NOCHANGE and/or NOCORRECT to the field changes the ACCEPT to "DISPLAY INSTITUTION_NAME" bui Martynt on update an error about "cannot write an empty record" is generated.<br>> <br>> We have logged an error with IBM.<br>> Martyn<br>> <br>> -----Original Message-----<br>> From: Bob Deskin [mailto:Bob.Deskin@ca.ibm.com]<br>> Sent: Wed 04-Nov-09 4:55 PM<br>> To: Thomson, Martyn EDUC:EX<br>> Cc: powerh-l@lists.sowder.com; powerh-l-bounces+bob.deskin=ca.ibm.com@lists.sowder.com<br>> Subject: Re: PH web changes alteredrecord of Reference table!<br>> <br>> QDESIGN must generate an ACCEPT verb on the REFERENCE file because the <br>> FIELD is not DISPLAY. If it's truly a REFERENCE file where you're looking <br>> up data based on another file's data (which is what the ACCESS does), you <br>> should be able to make the FIELD a DISPLAY field. <br>> <br>> If you need to enter data into that field, then the file should not be a <br>> REFERENCE file because it's not really just for a lookup.<br>> <br>> Bob<br>> <br>> <br>> <br>> From:<br>> "Thomson, Martyn EDUC:EX" <martyn.thomson@gov.bc.ca><br>> To:<br>> <powerh-l@lists.sowder.com><br>> Date:<br>> 2009-11-04 05:37 PM<br>> Subject:<br>> PH web changes alteredrecord of Reference table!<br>> Sent by:<br>> powerh-l-bounces+bob.deskin=ca.ibm.com@lists.sowder.com<br>> <br>> <br>> <br>> Posted on behalf of a colleague:<br>> <br>> We have an issue in powerhouse web version 8.40e and 8.40f where a <br>> reference file is having it's alteredrecord flag set to Y and as a result <br>> the error "*d* Not all changed records have been updated." is being <br>> returned.<br>> <br>> The issue occurs in the 2nd screen of a multi screen process for an <br>> application... The screens pass a series of parms between them as they <br>> run. The first screen gets the basic information writes it to the data <br>> base and determines which next screen to run based on the data that is <br>> available for this particular application.<br>> <br>> One of the fields (a name) selected the first screen is retrieved from the <br>> database and sent to the 2nd screen as a display however powerhouse is <br>> generating an accept verb in the Modify procedure, presumable so that that <br>> the PHCGIBIN will process it and display the value on the screen... <br>> Because it is an "accept" the altered record flag is set when the field is <br>> read and populated.<br>> <br>> The file - <br>> > file IF_INSTITUTION_VIEW in SFAS_DATABASE reference &<br>> > transaction query<br>> *W* Record IF_INSTITUTION_VIEW is not updatable.<br>> > <br>> > access via INSTITUTION_IDX &<br>> > using INSTITUTION_IDX of IF_APP_INTERNET_TMP<br>> > <br>> <br>> The field -<br>> > field INSTITUTION_NAME of IF_INSTITUTION_VIEW &<br>> > predisplay <br>> <br>> <br>> From the log...<br>> <br>> Action Command Modify<br>> Executing Modify Procedure<br>> 0837 BLOCK TRANSFER<br>> Watchpoint trap encountered at line: (837), for INSTITUTION_NAME <br>> OF IF_INSTITUTION_VIEW<br>> Old Value = " "<br>> ( from uninitialized buffer ) New Value = <br>> "XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX"<br>> 0839 ACCEPT INSTITUTION_NAME OF IF_INSTITUTION_VIEW<br>> 0840 ACCEPT T_PROG_START_YYYY<br>> 0841 ACCEPT T_PROG_START_MM<br>> 0842 ACCEPT T_PROG_START_DD<br>> 0843 ACCEPT T_PROG_END_YYYY<br>> 0844 ACCEPT T_PROG_END_MM<br>> 0845 ACCEPT T_PROG_END_DD<br>> 0846 ACCEPT P1<br>> 0847 ACCEPT P2<br>> 0848 ACCEPT P3<br>> 0849 ACCEPT P4<br>> 0850 ACCEPT P5<br>> 0851 ACCEPT T_ERROR<br>> 0852 END<br>> 0853 END<br>> <br>> Watchpoint trap encountered at line: (853), for ALTEREDRECORD OF <br>> IF_INSTITUTION_VIEW<br>> Old Value = FALSE<br>> New Value = TRUE <br>> <br>> Watchpoint trap encountered at line: (853), for INSTITUTION_NAME <br>> OF IF_INSTITUTION_VIEW<br>> Old Value = " "<br>> New Value = " "<br>> Action Command Update Stay<br>> <br>> We have change tried changing the file from reference to designer, <br>> Tried changing the field to nochange <br>> Tried changing the logic to use a temp field rather then the true field..<br>> <br>> The results were either the same or we get an attempt to write an empty <br>> record... Neither are acceptable.<br>> <br>> Any suggestions much appreciated.<br>> Martyn<br>> PH 8.4 on OpenVMS<br>> <br>> <br>> <br>> <br>> <br>> -- <br>> = = = = = = = = = = = = = = = = = = = = = = = = = = = =<br>> Mailing list: powerh-l@lists.sowder.com<br>> Subscribe: 'subscribe' in message body to <br>> powerh-l-request@lists.sowder.com<br>> Unsubscribe: 'unsubscribe &lt;password&gt;' in message body to <br>> powerh-l-request@lists.sowder.com<br>> http://lists.sowder.com/mailman/listinfo/powerh-l<br>> This list is closed, thus to post to the list you must be a subscriber.<br>> Add 'site:lists.sowder.com powerh-l' to your search terms to search the <br>> list archive at Google.<br>> <br>> <br>> <br>> <br>> <br>> -- <br>> = = = = = = = = = = = = = = = = = = = = = = = = = = = =<br>> Mailing list: powerh-l@lists.sowder.com<br>> Subscribe: 'subscribe' in message body to powerh-l-request@lists.sowder.com<br>> Unsubscribe: 'unsubscribe &lt;password&gt;' in message body to powerh-l-request@lists.sowder.com<br>> http://lists.sowder.com/mailman/listinfo/powerh-l<br>> This list is closed, thus to post to the list you must be a subscriber.<br>> Add 'site:lists.sowder.com powerh-l' to your search terms to search the list archive at Google.<br> <br /><hr />Get a great deal on Windows 7 and see how it works the way you want. <a href='http://go.microsoft.com/?linkid=9691812' target='_new'>Check out the offers on Windows 7now.</a></body>
</html>