# # ITSV GmbH # CCSB - Command and Control Database # # FILE: rwobj_loadflex # DESCRIPTION: load control definitions for DQUERY flexloadtable # # table CCILVD # @CCILVD._skip_condition.qexpression (this.cdata.STUNDEN=='' || this.cdata.STUNDEN==null || this.cdata.STUNDEN==undefined) @CCILVD._keep_unique.check_sql select * from CCILVD where JAHR=::JAHR:: and MONAT=::MONAT:: and TAG=::TAG:: and USKURZZ=::USKURZZ:: and PSP=::PSP:: @CCILVD._keep_unique.update_sql update CCILVD set STUNDEN=::STUNDEN:: where JAHR=::JAHR:: and MONAT=::MONAT:: and TAG=::TAG:: and USKURZZ=::USKURZZ:: and PSP=::PSP:: @CCILVD._keep_unique.post_check if (this.checkres.getRowCount()>0) { let chkrow = this.checkres.getRowObject(0); if (chkrow.STUNDEN==this.STUNDEN) { this.db_oper = "SKIP"; } else { this.db_oper = "UPDATE"; } } @CCILVD.JAHR @CCILVD.MONAT @CCILVD.TAG @CCILVD.PSP @CCILVD.PSPDETAIL.fromcolname BEZ @CCILVD.USKURZZ @CCILVD.STUNDEN @CCILVD.KOSTEN.constvalue 0