HDR*PowerBuilder0600]Applicazione principaleFRE*NOD* <<ENT*0600B'6ЇADc:\pb6_apps\presenze\presenze.pblrdrdrdak.srdak.srdsrdsrdareesettori_bak.srdareesettori_bak.srdDAT*release 19; datawindow(units=0 timer_interval=0 color=1073741824 brushmode=0 transparency=0 gradient.angle=0 gradient.color=8421504 gradient.focus=0 gradient.repetition.count=0 gradient.repetition.length=100 gradient.repetition.mode=0 gradient.scale=DAT*100 gradient.spread=100 gradient.transparency=0 picture.blur=0 picture.clip.bottom=0 picture.clip.left=0 picture.clip.right=0 picture.clip.top=0 picture.mode=0 picture.scale.x=100 picture.scale.y=100 picture.transparency=0 processing=1 HTMLDW=no printDAT*.printername="" print.documentname="" print.orientation = 0 print.margin.left = 110 print.margin.right = 110 print.margin.top = 96 print.margin.bottom = 96 print.paper.source = 0 print.paper.size = 0 print.canusedefaultprinter=yes print.prompt=no prinDAT*t.buttons=no print.preview.buttons=no print.cliptext=no print.overrideprintjob=no print.collate=yes print.background=no print.preview.background=no print.preview.outline=yes hidegrayline=no showbackcoloronxp=no picture.file="" grid.lines=0 ) header(hDAT*eight=92 color="536870912" transparency="0" gradient.color="8421504" gradient.transparency="0" gradient.angle="0" brushmode="0" gradient.repetition.mode="0" gradient.repetition.count="0" gradient.repetition.length="100" gradient.focus="0" gradient.scaDAT*le="100" gradient.spread="100" ) summary(height=0 color="536870912" transparency="0" gradient.color="8421504" gradient.transparency="0" gradient.angle="0" brushmode="0" gradient.repetition.mode="0" gradient.repetition.count="0" gradient.repetition.leDAT* ngth="100" gradient.focus="0" gradient.scale="100" gradient.spread="100" ) footer(height=0 color="536870912" transparency="0" gradient.color="8421504" gradient.transparency="0" gradient.angle="0" brushmode="0" gradient.repetition.mode="0" gradient.reDAT*"petition.count="0" gradient.repetition.length="100" gradient.focus="0" gradient.scale="100" gradient.spread="100" ) detail(height=104 color="536870912" transparency="0" gradient.color="8421504" gradient.transparency="0" gradient.angle="0" brushmode="DAT*$0" gradient.repetition.mode="0" gradient.repetition.count="0" gradient.repetition.length="100" gradient.focus="0" gradient.scale="100" gradient.spread="100" ) table(column=(type=char(10) updatewhereclause=yes name=id dbname="id" ) ) text(band=headDAT*&er alignment="2" text="Id" border="0" color="33554432" x="14" y="8" height="76" width="320" html.valueishtml="0" name=id_t visible="1" font.face="Tahoma" font.height="-12" font.weight="400" font.family="2" font.pitch="2" font.charset="0" backgroundDAT*(.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmode="0" background.gradient.repetition.mode="0" background.gradiDAT**ent.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="134217752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tDAT*,ooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" ) column(band=detail id=1 alignment="0" tabsequence=10 border="0" color="DAT*.33554432" x="14" y="8" height="88" width="320" format="[general]" html.valueishtml="0" name=id visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes font.face="Tahoma" font.height="-12" font.weight="4DAT*000" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" background.transparency="0" background.gradient.color="8421504" background.gradient.transparency="0" background.gradient.angle="0" background.brushmoDAT*2de="0" background.gradient.repetition.mode="0" background.gradient.repetition.count="0" background.gradient.repetition.length="100" background.gradient.focus="0" background.gradient.scale="100" background.gradient.spread="100" tooltip.backcolor="13421DAT*47752" tooltip.delay.initial="0" tooltip.delay.visible="32000" tooltip.enabled="0" tooltip.hasclosebutton="0" tooltip.icon="0" tooltip.isbubble="0" tooltip.maxwidth="0" tooltip.textcolor="134217751" tooltip.transparency="0" transparency="0" ) htmltablDAT*6e(border="1" ) htmlgen(clientevents="1" clientvalidation="1" clientcomputedfields="1" clientformatting="0" clientscriptable="0" generatejavascript="1" encodeselflinkargs="1" netscapelayers="0" pagingmethod=0 generatedddwframes="1" ) xhtmlgen() cssgeDAT*8n(sessionspecific="0" ) xmlgen(inline="0" ) xsltgen() jsgen() export.xml(headgroups="1" includewhitespace="0" metadatatype=0 savemetadata=0 ) import.xml() export.pdf(method=2 distill.custompostscript="0" xslfop.print="0" nativepdf.customsize=0 nDAT*ativepdf.customorientation=0 nativepdf.pdfstandard=0 nativepdf.useprintspec=no ) export.xhtml() DAT*<PDW1900ld@dldddd;./:Njknn`` ABUVY\]^it\DAT*>  !#%'), id_t$1$0$ 134217751$ 134217752$} 32000<DAT*@%TahomaTahoma$2$-12$400$ 536870912$8421504$d100$ 33554432$"14DAT*l$$8$&L76$(@320%*+IdId"-0tth00<1/DAT*Drelease 5; datawindow(units=0 timer_interval=0 color=12632256 processing=0 print.documentname="" print.orientation = 0 print.margin.left = 110 print.margin.right = 110 print.margin.top = 97 print.margin.bottom = 97 print.paper.source = 0 print.paper.size = 0 print.prompt=no print.buttons=no print.preview.buttons=no ) summary(height=4 color="536870912" ) footer(height=0 color="536870912" ) detail(height=164 color="536870912" ) table(column=(type=char(7) update=yes updatewhereclause=yes key=yesDAT*F name=matricola dbname="cartellini.matricola" ) column=(type=date update=yes updatewhereclause=yes key=yes name=data_timbratura dbname="cartellini.data_timbratura" ) column=(type=char(2) update=yes updatewhereclause=yes name=cod_turno dbname="cartellini.cod_turno" ) column=(type=long update=yes updatewhereclause=yes name=drn dbname="cartellini.drn" ) column=(type=long update=yes updatewhereclause=yes name=ntt dbname="cartellini.ntt" ) column=(type=long update=yes updatewhereclause=yes naDAT*Hme=ntd dbname="cartellini.ntd" ) column=(type=long update=yes updatewhereclause=yes name=ext dbname="cartellini.ext" ) column=(type=long update=yes updatewhereclause=yes name=c1_4 dbname="cartellini.c1_4" values=" 1/ 0" ) column=(type=long update=yes updatewhereclause=yes name=fsp dbname="cartellini.fsp" ) column=(type=long update=yes updatewhereclause=yes name=fer dbname="cartellini.fer" ) column=(type=long updatewhereclause=yes name=nott dbname="cartellini.nott" ) column=(type=long uDAT*Jpdate=yes updatewhereclause=yes name=fst dbname="cartellini.fst" ) column=(type=long update=yes updatewhereclause=yes name=fnt dbname="cartellini.fnt" ) column=(type=long update=yes updatewhereclause=yes name=mr1 dbname="cartellini.mr1" ) column=(type=long update=yes updatewhereclause=yes name=mr2 dbname="cartellini.mr2" ) column=(type=long update=yes updatewhereclause=yes name=thr dbname="cartellini.thr" ) column=(type=long update=yes updatewhereclause=yes name=rit dbname="cartellini.riDAT*Lt" ) column=(type=long update=yes updatewhereclause=yes name=per dbname="cartellini.per" ) column=(type=long update=yes updatewhereclause=yes name=nonret dbname="cartellini.nonret" ) column=(type=char(1) update=yes updatewhereclause=yes name=mensa dbname="cartellini.mensa" ) column=(type=char(10) update=yes updatewhereclause=yes name=causale1 dbname="cartellini.causale1" ) column=(type=char(10) update=yes updatewhereclause=yes name=causale2 dbname="cartellini.causale2" ) column=(type=cDAT*Nhar(10) update=yes updatewhereclause=yes name=causale3 dbname="cartellini.causale3" ) column=(type=char(10) update=yes updatewhereclause=yes name=causale4 dbname="cartellini.causale4" ) column=(type=char(10) update=yes updatewhereclause=yes name=causale5 dbname="cartellini.causale5" ) column=(type=char(10) update=yes updatewhereclause=yes name=causale6 dbname="cartellini.causale6" ) column=(type=time updatewhereclause=yes name=h1_o dbname="cartellini.h1_o" ) column=(type=time updatewhereDAT*Pclause=yes name=h2_o dbname="cartellini.h2_o" ) column=(type=time updatewhereclause=yes name=h3_o dbname="cartellini.h3_o" ) column=(type=time updatewhereclause=yes name=h4_o dbname="cartellini.h4_o" ) column=(type=time updatewhereclause=yes name=h5_o dbname="cartellini.h5_o" ) column=(type=time updatewhereclause=yes name=h6_o dbname="cartellini.h6_o" ) column=(type=time updatewhereclause=yes name=h7_o dbname="cartellini.h7_o" ) column=(type=time updatewhereclause=yes name=h8_o dbname=DAT*R"cartellini.h8_o" ) column=(type=time updatewhereclause=yes name=h9_o dbname="cartellini.h9_o" ) column=(type=time updatewhereclause=yes name=h10_o dbname="cartellini.h10_o" ) column=(type=time updatewhereclause=yes name=h11_o dbname="cartellini.h11_o" ) column=(type=time updatewhereclause=yes name=h12_o dbname="cartellini.h12_o" ) column=(type=char(1) updatewhereclause=yes name=v1_o dbname="cartellini.v1_o" ) column=(type=char(1) updatewhereclause=yes name=v2_o dbname="cartellini.v2_oDAT*T" ) column=(type=char(1) updatewhereclause=yes name=v3_o dbname="cartellini.v3_o" ) column=(type=char(1) updatewhereclause=yes name=v4_o dbname="cartellini.v4_o" ) column=(type=char(1) updatewhereclause=yes name=v5_o dbname="cartellini.v5_o" ) column=(type=char(1) updatewhereclause=yes name=v6_o dbname="cartellini.v6_o" ) column=(type=char(1) updatewhereclause=yes name=v7_o dbname="cartellini.v7_o" ) column=(type=char(1) updatewhereclause=yes name=v8_o dbname="cartellini.v8_o" ) coluDAT*Vmn=(type=char(1) updatewhereclause=yes name=v9_o dbname="cartellini.v9_o" ) column=(type=char(1) updatewhereclause=yes name=v10_o dbname="cartellini.v10_o" ) column=(type=char(1) updatewhereclause=yes name=v11_o dbname="cartellini.v11_o" ) column=(type=char(1) updatewhereclause=yes name=v12_o dbname="cartellini.v12_o" ) column=(type=time update=yes updatewhereclause=yes name=h1 dbname="cartellini.h1" ) column=(type=time update=yes updatewhereclause=yes name=h2 dbname="cartellini.h2" ) DAT*Xcolumn=(type=time update=yes updatewhereclause=yes name=h3 dbname="cartellini.h3" ) column=(type=time update=yes updatewhereclause=yes name=h4 dbname="cartellini.h4" ) column=(type=time update=yes updatewhereclause=yes name=h5 dbname="cartellini.h5" ) column=(type=time update=yes updatewhereclause=yes name=h6 dbname="cartellini.h6" ) column=(type=time update=yes updatewhereclause=yes name=h7 dbname="cartellini.h7" ) column=(type=time update=yes updatewhereclause=yes name=h8 dbname="carteDAT*Zllini.h8" ) column=(type=time update=yes updatewhereclause=yes name=h9 dbname="cartellini.h9" ) column=(type=time update=yes updatewhereclause=yes name=h10 dbname="cartellini.h10" ) column=(type=time update=yes updatewhereclause=yes name=h11 dbname="cartellini.h11" ) column=(type=time update=yes updatewhereclause=yes name=h12 dbname="cartellini.h12" ) column=(type=char(1) update=yes updatewhereclause=yes name=v1 dbname="cartellini.v1" ) column=(type=char(1) update=yes updatewhereclauseDAT*\=yes name=v2 dbname="cartellini.v2" ) column=(type=char(1) update=yes updatewhereclause=yes name=v3 dbname="cartellini.v3" ) column=(type=char(1) update=yes updatewhereclause=yes name=v4 dbname="cartellini.v4" ) column=(type=char(1) update=yes updatewhereclause=yes name=v5 dbname="cartellini.v5" ) column=(type=char(1) update=yes updatewhereclause=yes name=v6 dbname="cartellini.v6" ) column=(type=char(1) update=yes updatewhereclause=yes name=v7 dbname="cartellini.v7" ) column=(type=charDAT*^(1) update=yes updatewhereclause=yes name=v8 dbname="cartellini.v8" ) column=(type=char(1) update=yes updatewhereclause=yes name=v9 dbname="cartellini.v9" ) column=(type=char(1) update=yes updatewhereclause=yes name=v10 dbname="cartellini.v10" ) column=(type=char(1) update=yes updatewhereclause=yes name=v11 dbname="cartellini.v11" ) column=(type=char(1) update=yes updatewhereclause=yes name=v12 dbname="cartellini.v12" ) retrieve="PBSELECT( VERSION(400) TABLE(NAME=~"cartellini~" ) COLUMN(DAT*`NAME=~"cartellini.matricola~") COLUMN(NAME=~"cartellini.data_timbratura~") COLUMN(NAME=~"cartellini.cod_turno~") COLUMN(NAME=~"cartellini.drn~") COLUMN(NAME=~"cartellini.ntt~") COLUMN(NAME=~"cartellini.ntd~") COLUMN(NAME=~"cartellini.ext~") COLUMN(NAME=~"cartellini.c1_4~") COLUMN(NAME=~"cartellini.fsp~") COLUMN(NAME=~"cartellini.fer~") COLUMN(NAME=~"cartellini.nott~") COLUMN(NAME=~"cartellini.fst~") COLUMN(NAME=~"cartellini.fnt~") COLUMN(NAME=~"cartellini.mr1~") COLUMN(NAME=~"cartellini.mr2~") COLDAT*bUMN(NAME=~"cartellini.thr~") COLUMN(NAME=~"cartellini.rit~") COLUMN(NAME=~"cartellini.per~") COLUMN(NAME=~"cartellini.nonret~") COLUMN(NAME=~"cartellini.mensa~") COLUMN(NAME=~"cartellini.causale1~") COLUMN(NAME=~"cartellini.causale2~") COLUMN(NAME=~"cartellini.causale3~") COLUMN(NAME=~"cartellini.causale4~") COLUMN(NAME=~"cartellini.causale5~") COLUMN(NAME=~"cartellini.causale6~") COLUMN(NAME=~"cartellini.h1_o~") COLUMN(NAME=~"cartellini.h2_o~") COLUMN(NAME=~"cartellini.h3_o~") COLUMN(NAME=~"carteDAT*dllini.h4_o~") COLUMN(NAME=~"cartellini.h5_o~") COLUMN(NAME=~"cartellini.h6_o~") COLUMN(NAME=~"cartellini.h7_o~") COLUMN(NAME=~"cartellini.h8_o~") COLUMN(NAME=~"cartellini.h9_o~") COLUMN(NAME=~"cartellini.h10_o~") COLUMN(NAME=~"cartellini.h11_o~") COLUMN(NAME=~"cartellini.h12_o~") COLUMN(NAME=~"cartellini.v1_o~") COLUMN(NAME=~"cartellini.v2_o~") COLUMN(NAME=~"cartellini.v3_o~") COLUMN(NAME=~"cartellini.v4_o~") COLUMN(NAME=~"cartellini.v5_o~") COLUMN(NAME=~"cartellini.v6_o~") COLUMN(NAME=~"cartellinDAT*fi.v7_o~") COLUMN(NAME=~"cartellini.v8_o~") COLUMN(NAME=~"cartellini.v9_o~") COLUMN(NAME=~"cartellini.v10_o~") COLUMN(NAME=~"cartellini.v11_o~") COLUMN(NAME=~"cartellini.v12_o~") COLUMN(NAME=~"cartellini.h1~") COLUMN(NAME=~"cartellini.h2~") COLUMN(NAME=~"cartellini.h3~") COLUMN(NAME=~"cartellini.h4~") COLUMN(NAME=~"cartellini.h5~") COLUMN(NAME=~"cartellini.h6~") COLUMN(NAME=~"cartellini.h7~") COLUMN(NAME=~"cartellini.h8~") COLUMN(NAME=~"cartellini.h9~") COLUMN(NAME=~"cartellini.h10~") COLUMN(NAME=~DAT*h"cartellini.h11~") COLUMN(NAME=~"cartellini.h12~") COLUMN(NAME=~"cartellini.v1~") COLUMN(NAME=~"cartellini.v2~") COLUMN(NAME=~"cartellini.v3~") COLUMN(NAME=~"cartellini.v4~") COLUMN(NAME=~"cartellini.v5~") COLUMN(NAME=~"cartellini.v6~") COLUMN(NAME=~"cartellini.v7~") COLUMN(NAME=~"cartellini.v8~") COLUMN(NAME=~"cartellini.v9~") COLUMN(NAME=~"cartellini.v10~") COLUMN(NAME=~"cartellini.v11~") COLUMN(NAME=~"cartellini.v12~")WHERE( EXP1 =~"cartellini.matricola~" OP =~"=~" EXP2 =~":ls_matricolaDAT*j~" LOGIC =~"and~" ) WHERE( EXP1 =~"year(cartellini.data_timbratura)~" OP =~"=~" EXP2 =~":li_anno~" LOGIC =~"and~" ) WHERE( EXP1 =~"month(cartellini.data_timbratura)~" OP =~"=~" EXP2 =~":li_mese~" ) ) ARG(NAME = ~"ls_matricola~" TYPE = string) ARG(NAME = ~"li_mese~" TYPE = number) ARG(NAME = ~"li_anno~" TYPE = number) " update="cartellini" updatewhere=1 updatekeyinplace=no arguments=(("ls_matricola", string),("li_mese", number),("li_anno", number)) ) group(level=1 header.heDAT*ight=0 trailer.height=0 by=("matricola" ) header.color="536870912" trailer.color="536870912" ) htmltable(border="1" cellpadding="0" cellspacing="0" generatecss="no" nowrap="yes")