FILE <NAME> DELETE in QUICK
James B. Byrne
byrnejb at harte-lyne.ca
Thu Dec 5 14:53:38 CST 2024
I am trying ti understand how the DELETE option on a FILE statement works in
practice.
I have this in a QUICK screen:
FILE TRANSACTIONS PRIMARY
ACCESS VIA TRANS-IDENT REQUEST TRANS-IDENT
FILE TRANNOTE DELETE ALIAS NOTE-DELETE
SELECT IF &
RECORD-TYPE OF NOTE-DELETE EQ "NOTE" &
AND &
LINE-NUMBER OF NOTE-DELETE GE 980000 &
AND &
USER-ID OF NOTE-DELETE EQ "QZARCCBC"
I have this in a designer procedure:
PROCEDURE INTERNAL REMOVE-NOTES
BEGIN
PUT NOTE-DELETE
END
PROCEDURE INTERNAL NOTES
BEGIN
LET QKT-NOTE-TRAN = TRANS-IDENT OF TRANSACTIONS
LET QKT-NOTE-USER = "QKARCCBC"
DO INTERNAL REMOVE-NOTES
. . .
I have these entries in the TRANNOTE file:
IN365362 980100 QKARCCBC
IN365362 980100 QKARCCBC
IN365362 980100 QKARCCBC
IN365362 980100 QKARCCBC
IN365362 980100 QKARCCBC
IN365362 980100 QKARCCBC
IN365362 980100 QKARCCBC
IN365362 980100 QKARCCBC
IN365362 980100 QKARCCBC
IN365362 980101 QKARCCBC
IN365362 980101 QKARCCBC
IN365362 980101 QKARCCBC
IN365362 980101 QKARCCBC
IN365362 980101 QKARCCBC
IN365362 990100 QKARCCBC
IN365362 990100 QKARCCBC
IN365362 990100 QKARCCBC
IN365362 990100 QKARCCBC
The TRANS-IDENT of TRANSACTIONS is IN365362. But none of these records in
TRANNOTE are deleted when the internal procedure NOTES is called.
What am I not understanding here?
More information about the powerh-l
mailing list