PH web changes alteredrecord of Reference table!

[Bob Deskin]

QDESIGN must generate an ACCEPT verb on the REFERENCE file because the 
FIELD is not DISPLAY. If it's truly a REFERENCE file where you're looking 
up data based on another file's data (which is what the ACCESS does), you 
should be able to make the FIELD a DISPLAY field. 

If you need to enter data into that field, then the file should not be a 
REFERENCE file because it's not really just for a lookup.

Bob



From:
"Thomson, Martyn EDUC:EX" <martyn.thomson at gov.bc.ca>
To:
<powerh-l at lists.sowder.com>
Date:
2009-11-04 05:37 PM
Subject:
PH web changes alteredrecord of Reference table!
Sent by:
powerh-l-bounces+bob.deskin=ca.ibm.com at lists.sowder.com



Posted on behalf of a colleague:

We have an issue in powerhouse web version 8.40e and 8.40f where a 
reference file is having it’s alteredrecord flag set to Y and as a result 
the error "*d* Not all changed records have been updated." is being 
returned.

The issue occurs in the 2nd screen of a multi screen process for an 
application... The screens pass a series of parms between them as they 
run. The first screen gets the basic information writes it to the data 
base and determines which next screen to run based on the data that is 
available for this particular application.

One of the fields (a name) selected the first screen is retrieved from the 
database and sent to the 2nd screen as a display however powerhouse is 
generating an accept verb in the Modify procedure, presumable so that that 
the PHCGIBIN will process it and display the value on the screen... 
Because it is an “accept” the altered record flag is set when the field is 
read and populated.

The file - 
> file IF_INSTITUTION_VIEW in SFAS_DATABASE reference &
>       transaction query
*W* Record IF_INSTITUTION_VIEW is not updatable.
> 
>   access via INSTITUTION_IDX                  &
>       using INSTITUTION_IDX of IF_APP_INTERNET_TMP
> 

The field -
> field INSTITUTION_NAME of IF_INSTITUTION_VIEW        &
>      predisplay