SHOW:
|
|
- or go back to the newest paste.
| 1 | - | CONSTRUCTOR FUNCTION Obj$Campaign(id NUMBER DEFAULT NULL) RETURN SELF AS RESULT AS |
| 1 | + | MEMBER PROCEDURE save IS |
| 2 | - | BEGIN |
| 2 | + | BEGIN |
| 3 | - | IF id IS NULL THEN RETURN; END IF; |
| 3 | + | IF id IS NULL THEN RETURN; END IF; |
| 4 | - | WITH a AS ( |
| 4 | + | |
| 5 | - | SELECT cc.campaign_id, |
| 5 | + | UPDATE client_campaign |
| 6 | - | cc.client_id, |
| 6 | + | SET status_id = SELF.Status, |
| 7 | - | cc.campaign_script, |
| 7 | + | campaign_next = SELF.NextDate, |
| 8 | - | cc.object_id, |
| 8 | + | campaign_end = SELF.EndDate, |
| 9 | - | cc.type_id, |
| 9 | + | campaign_step = SELF.State |
| 10 | - | cc.status_id, |
| 10 | + | WHERE campaign_id = SELF.ID; |
| 11 | - | oc.obj_code, |
| 11 | + | END save; |
