PH web changes alteredrecord of Reference table!
Peter Bateman
peterbateman808 at hotmail.com
Fri Nov 6 14:40:19 CST 2009
Hi Martyn:
As a workaround I would put a get on the reference file in the PREUPDATE procedure.
This hopefully would reset the record status to OLD UNALTERED.
Is there a PUT on the reference file in the UPDATE procedure??
Regards,
Peter Bateman
09 09:36:36 -0800
> From: martyn.thomson at gov.bc.ca
> To: Bob.Deskin at ca.ibm.com
> CC: powerh-l-bounces+bob.deskin=ca.ibm.com at lists.sowder.com; powerh-l at lists.sowder.com
>
> Hi Bob.
> 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.
> 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.
>
> We have logged an error with IBM.
> Martyn
>
> -----Original Message-----
> From: Bob Deskin [mailto:Bob.Deskin at ca.ibm.com]
> Sent: Wed 04-Nov-09 4:55 PM
> To: Thomson, Martyn EDUC:EX
> Cc: powerh-l at lists.sowder.com; powerh-l-bounces+bob.deskin=ca.ibm.com at lists.sowder.com
> Subject: Re: PH web changes alteredrecord of Reference table!
>
> 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
>
>
> From the log...
>
> Action Command Modify
> Executing Modify Procedure
> 0837 BLOCK TRANSFER
> Watchpoint trap encountered at line: (837), for INSTITUTION_NAME
> OF IF_INSTITUTION_VIEW
> Old Value = " "
> ( from uninitialized buffer ) New Value =
> "XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX"
> 0839 ACCEPT INSTITUTION_NAME OF IF_INSTITUTION_VIEW
> 0840 ACCEPT T_PROG_START_YYYY
> 0841 ACCEPT T_PROG_START_MM
> 0842 ACCEPT T_PROG_START_DD
> 0843 ACCEPT T_PROG_END_YYYY
> 0844 ACCEPT T_PROG_END_MM
> 0845 ACCEPT T_PROG_END_DD
> 0846 ACCEPT P1
> 0847 ACCEPT P2
> 0848 ACCEPT P3
> 0849 ACCEPT P4
> 0850 ACCEPT P5
> 0851 ACCEPT T_ERROR
> 0852 END
> 0853 END
>
> Watchpoint trap encountered at line: (853), for ALTEREDRECORD OF
> IF_INSTITUTION_VIEW
> Old Value = FALSE
> New Value = TRUE
>
> Watchpoint trap encountered at line: (853), for INSTITUTION_NAME
> OF IF_INSTITUTION_VIEW
> Old Value = " "
> New Value = " "
> Action Command Update Stay
>
> We have change tried changing the file from reference to designer,
> Tried changing the field to nochange
> Tried changing the logic to use a temp field rather then the true field..
>
> The results were either the same or we get an attempt to write an empty
> record... Neither are acceptable.
>
> Any suggestions much appreciated.
> Martyn
> PH 8.4 on OpenVMS
>
>
>
>
>
> --
> = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Mailing list: powerh-l at lists.sowder.com
> Subscribe: 'subscribe' in message body to
> powerh-l-request at lists.sowder.com
> Unsubscribe: 'unsubscribe <password>' in message body to
> powerh-l-request at lists.sowder.com
> http://lists.sowder.com/mailman/listinfo/powerh-l
> This list is closed, thus to post to the list you must be a subscriber.
> Add 'site:lists.sowder.com powerh-l' to your search terms to search the
> list archive at Google.
>
>
>
>
>
> --
> = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Mailing list: powerh-l at lists.sowder.com
> Subscribe: 'subscribe' in message body to powerh-l-request at lists.sowder.com
> Unsubscribe: 'unsubscribe <password>' in message body to powerh-l-request at lists.sowder.com
> http://lists.sowder.com/mailman/listinfo/powerh-l
> This list is closed, thus to post to the list you must be a subscriber.
> Add 'site:lists.sowder.com powerh-l' to your search terms to search the list archive at Google.
_________________________________________________________________
Windows Live: Friends get your Flickr, Yelp, and Digg updates when they e-mail you.
http://go.microsoft.com/?linkid=9691817
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20091106/b30bc938/attachment.htm
More information about the powerh-l
mailing list