SV: PH web changes alteredrecord of Reference table!

[Jari.Kaljunen at sergel.com]

Hi,

if I get the picture right:
 make your own modify procedure without accept for fields in a view.

PH doesn't know that much about views but uses them like any tables.

/Jari
 

-----Ursprungligt meddelande-----
Från: powerh-l-bounces+jari.kaljunen=sergel.com at lists.sowder.com [mailto:powerh-l-bounces+jari.kaljunen=sergel.com at lists.sowder.com] För Thomson, Martyn EDUC:EX
Skickat: den 4 november 2009 23:32
Till: powerh-l at lists.sowder.com
Ämne: PH web changes alteredrecord of Reference table!

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