Delete Procedure
GGrimm@pcc-structurals.com
GGrimm@pcc-structurals.com
Mon, 30 Apr 2001 16:40:25 -0700
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