FW: Delete Procedure

[Edis, Bob]

What platform? what version?

I suggest that you try using the debug feature of Quick.  This has worked
nicely for me in the past to find why the screen behaves differently for
different records.

Blue

-----Original Message-----
From: GGrimm@pcc-structurals.com [mailto:GGrimm@pcc-structurals.com]
Sent: Monday, April 30, 2001 6:40 PM
To: powerh-l@lists.swau.edu
Subject: Delete Procedure 


     On some situation (yet to be ascertained), a partial update occurs 
     about 5% of the time when updating cached records if record(s), have 
     been deleted with a range of numbers, for example: D-9/10.
     
     Has anyone an idea what could cause this from the below snippet 
     without having to see the entire code?  The data base is Oracle 8.06.  
     Could changing a field in a deleted record after the delete cause a 
     problem?
     
     Following is a snippet of the code, primary and three secondary files, 
     no DELETE files, secondary retrieval done in FIND procedure with no 
     records is possible on any of the three secondaries.  The absence of 
     secondary(s) is not the cause of the partial Update that happens.  
     
     ---------
     FILE TIME_ATTEND  PRIMARY       OCCURS 13       NOITEMS CACHE 255
        ACCESS VIA EMPLOYEENO, SHIFT_DATE, SHIFT_NO, ENTITY_CODE &
        USING EMPLOYEENO OF EMPLOYEES, T_SHIFT_DATE,             &
              T_SHIFT, TIME_ATTEND_ENTITY                        &
                    ORDERBY EMPLOYEENO, SHIFT_DATE, SEQ_NUM
        ACCESS VIA SHIFT_DATE, DEPT_CODE, SHIFT_NO, ENTITY_CODE     &
        USING T_SHIFT_DATE, T_REQ_DEPT, T_SHIFT, TIME_ATTEND_ENTITY &
                    ORDERBY EMPLOYEENO, SHIFT_DATE, SEQ_NUM
     FILE TIME_ATTEND_2  SECONDARY  OCCURS WITH TIME_ATTEND  NOITEMS
     FILE TIME_ATTEND_2  SECONDARY  OCCURS WITH TIME_ATTEND  NOITEMS &
                                          ALIAS TIME_ATTEND_2IN 
     FILE TIME_ATTEND    SECONDARY  OCCURS WITH TIME_ATTEND  NOITEMS &
                                          ALIAS TIME_ATTEND_IN 
     . . . . .
     PROCEDURE DELETE
     BEGIN
          DELETE TIME_ATTEND_2IN
          DELETE TIME_ATTEND_IN
          DELETE TIME_ATTEND_2
          DELETE TIME_ATTEND
     END
      
     
     
     
     


= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.