fbenoist68
/
mobileportal
1
0
Fork 0
Code Issues 739 Pull Requests Packages Projects Releases Wiki Activity

[FogBugz #111] TRIGGER AFTER DELETE SUR CF pour CF_NON_DUPLICATION #173

New Issue
Open
opened 2023-07-03 23:35:58 +02:00 by fbenoist68 · 6 comments
fbenoist68 commented 2023-07-03 23:35:58 +02:00
Owner

Assigned To: CLOSED
Project: CAISSE
Area: awcaisse
Category: Demande
Priority: A fixer impérativement

Assigned To: CLOSED Project: CAISSE Area: awcaisse Category: Demande Priority: A fixer impérativement
fbenoist68 commented 2023-07-03 23:35:59 +02:00
Poster
Owner

Event ID: 460
Date: 2013-03-08T15:54:00Z
Person: Frederik Benoist
Description: Fermé par Frederik Benoist

Event ID: 460 Date: 2013-03-08T15:54:00Z Person: Frederik Benoist Description: Fermé par Frederik Benoist
fbenoist68 commented 2023-07-03 23:36:01 +02:00
Poster
Owner

Event ID: 459
Date: 2013-03-08T15:54:00Z
Person: Frederik Benoist
Description: Resolved (Responded) and assigned to Frederik Benoist by Frederik Benoist

Effectué le 08/03/2013 8h45

Event ID: 459 Date: 2013-03-08T15:54:00Z Person: Frederik Benoist Description: Resolved (Responded) and assigned to Frederik Benoist by Frederik Benoist Effectué le 08/03/2013 8h45
fbenoist68 commented 2023-07-03 23:36:02 +02:00
Poster
Owner

Event ID: 458
Date: 2013-03-07T16:36:25Z
Person: Frederik Benoist
Description: Modifié par Frederik Benoist

Event ID: 458 Date: 2013-03-07T16:36:25Z Person: Frederik Benoist Description: Modifié par Frederik Benoist
fbenoist68 commented 2023-07-03 23:36:03 +02:00
Poster
Owner

Event ID: 457
Date: 2013-03-07T16:16:11Z
Person: Frederik Benoist
Description: Modifié par Frederik Benoist

 

CREATE OR REPLACE TRIGGER tr_bd_client_facture
    BEFORE DELETE
    ON client_facture
    REFERENCING NEW AS new OLD AS old
    FOR EACH ROW
BEGIN
    DELETE client_facture_non_duplication cfnd
     WHERE cfnd.num_facture = :old.num_facture;
END;
/
Event ID: 457 Date: 2013-03-07T16:16:11Z Person: Frederik Benoist Description: Modifié par Frederik Benoist <p> &nbsp;</p> <div> <div> CREATE OR REPLACE TRIGGER tr_bd_client_facture</div> <div> &nbsp; &nbsp; BEFORE DELETE</div> <div> &nbsp; &nbsp; ON client_facture</div> <div> &nbsp; &nbsp; REFERENCING NEW AS new OLD AS old</div> <div> &nbsp; &nbsp; FOR EACH ROW</div> <div> BEGIN</div> <div> &nbsp; &nbsp; DELETE client_facture_non_duplication cfnd</div> <div> &nbsp; &nbsp; &nbsp;WHERE cfnd.num_facture = :old.num_facture;</div> <div> END;</div> </div> <div> /</div>
fbenoist68 commented 2023-07-03 23:36:05 +02:00
Poster
Owner

Event ID: 456
Date: 2013-03-07T16:08:46Z
Person: Frederik Benoist
Description: Attribué à Frederik Benoist par Frederik Benoist

Event ID: 456 Date: 2013-03-07T16:08:46Z Person: Frederik Benoist Description: Attribué à Frederik Benoist par Frederik Benoist
fbenoist68 commented 2023-07-03 23:36:06 +02:00
Poster
Owner

Event ID: 455
Date: 2013-03-07T16:08:46Z
Person: Frederik Benoist
Description: Ouvert par Frederik Benoist

Event ID: 455 Date: 2013-03-07T16:08:46Z Person: Frederik Benoist Description: Ouvert par Frederik Benoist
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
main
Labels
Clear labels
No items
No Label
Milestone
Clear milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
No Assignees
1 Participants
Notifications
Due Date
The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: fbenoist68/mobileportal#173
There is no content yet.
Delete Branch "%!s(<nil>)"

Deleting a branch is permanent. Although the deleted branch may exist for a short time before cleaning up, in most cases it CANNOT be undone. Continue?