>PROC UPDTCAMPAIGN > >SELE CURRDATA >CLOSE INDE > >SELE Edcpgntmpl >PACK && REMOVES RECORDS DELETED TO TO ERROR VALIDATIONS >INDE ON SCID TAG SCID > >SELE CURRDATA >IF RECCOUNT() = 0 > APPE FROM EDCPGNTMPL >ELSE > SCATTER FIELDS BRAND,SCID,BOUNCES,OPENS,TOTALCLICKS,UNIQUECLICKS,; > OPTOUTS,TOTALMAILED,NETMAILED NAME UPDRECS BLANK > STORE " " TO LCUPDT > STORE 0 TO LNUPDREC > 1 > SCAN > STORE SCID TO LNSCID > IF SEEK(LNSCID,'EDCPGNTMPL') > > IF BOUNCES <> EDCPGNTMPL.BOUNCES > REPL BOUNCES WITH EDCPGNTMPL.BOUNCES > SCATTER FIELDS BRAND,SCID,BOUNCES NAME UPDRECS ADDI > DO RECORDUPDATES > LCUPDT= "Y" > ELSE > LCUPDT= "" > ENDIF > > IF OPENS <> EDCPGNTMPL.OPENS > REPL OPENS WITH EDCPGNTMPL.OPENS > SCATTER FIELDS BRAND,SCID,OPENS NAME UPDRECS ADDI > DO RECORDUPDATES > LCUPDT= "Y" > ELSE > LCUPDT= "" > ENDIF > > ENDIF > > IF !EMPT(LCUPDT) > LNUPDREC= LNUPDREC+1 > ENDIF > ENDSCAN > >WAIT WIND ALLT(STR(LNUPDREC))+" RECORD(S) WERE UPDATED IN THE CAMPAIGN MASTER FILE" TIME 1 >ENDIF > >ENDPROC > >******************************************************** > >PROC RECORDUPDATES > >IF USED('CAMPAIGNUPDATES') > SELE CAMPAIGNUPDATES >ELSE > USE CAMPAIGNUPDATES IN 0 EXCL > SELE CAMPAIGNUPDATES >ENDIF >APPEND BLANK >GATHER NAME UPDRECS >REPL ALL DATE WITH DATE() FOR EMPT(DATE) >REPL ALL FILEDATE WITH VAL(PCFILENAME) FOR EMPT(FILEDATE) > >ENDPROC >