PH web changes alteredrecord of Reference table!

[Lorry Litman]

Along the same lines of the open read, perhaps changing
Transaction query to Transaction query for query,process,update

Thanx
        Lorry
-----Original Message-----
From: powerh-l-bounces+llitman=manitoba-ehealth.ca at lists.sowder.com
[mailto:powerh-l-bounces+llitman=manitoba-ehealth.ca at lists.sowder.com]
On Behalf Of Richard Witkopp
Sent: Wednesday, November 04, 2009 4:50 PM
To: powerh-l at lists.sowder.com
Subject: RE: PH web changes alteredrecord of Reference table!

OPEN READ on the file statement?

-----Original Message-----
From: powerh-l-bounces+rwitkopp=phxa.com at lists.sowder.com
[mailto:powerh-l-bounces+rwitkopp=phxa.com at lists.sowder.com] On Behalf
Of
Thomson, Martyn EDUC:EX
Sent: Wednesday, November 04, 2009 2:32 PM
To: powerh-l at lists.sowder.com
Subject: 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