1234567891011121314151617181920212223242526272829303132333435363738 |
- $PBExportHeader$d_extr_find.srd
- release 9;
- datawindow(units=0 timer_interval=0 color=134217739 processing=0 HTMLDW=no print.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 print.buttons=no print.preview.buttons=no print.cliptext=no print.overrideprintjob=no print.collate=yes hidegrayline=no )
- header(height=20 color="536870912" )
- summary(height=0 color="536870912" )
- footer(height=24 color="536870912" )
- detail(height=88 color="536870912" )
- table(column=(type=long update=yes updatewhereclause=yes key=yes name=rptid dbname="u_RptQueries.rptid" )
- column=(type=long update=yes updatewhereclause=yes key=yes name=list_sort dbname="u_RptQueries.list_sort" )
- column=(type=long update=yes updatewhereclause=yes name=column_number dbname="u_RptQueries.Column_number" )
- column=(type=char(10) update=yes updatewhereclause=yes name=column_datatype dbname="u_RptQueries.Column_DataType" initial="numeric_operators" )
- column=(type=char(11) update=yes updatewhereclause=yes name=numeric_operators dbname="u_RptQueries.numeric_Operators" values="等于 =/大于 >/小于 </大于等于 >=/小于等于 <=/不等于 <>/" )
- column=(type=char(11) update=yes updatewhereclause=yes name=string_operators dbname="u_RptQueries.string_Operators" values="包含 LIKE/不包含 NOT LIKE/等于 =/不等于 <>/大于 >/小于 </大于等于 >=/小于等于 <=/" )
- column=(type=char(11) update=yes updatewhereclause=yes name=datetime_operators dbname="u_RptQueries.datetime_Operators" values="大于 >/小于 </大于等于 >=/小于等于 <=/等于 =/不等于 <>/" )
- column=(type=char(20) update=yes updatewhereclause=yes name=value dbname="u_RptQueries.Value" )
- column=(type=datetime update=yes updatewhereclause=yes name=datetime_value dbname="u_RptQueries.datetime_Value" )
- column=(type=char(3) update=yes updatewhereclause=yes name=join_operator dbname="u_RptQueries.Join_Operator" values="并且 AND/或者 OR/" )
- column=(type=char(3) update=yes updatewhereclause=yes name=not_operator dbname="u_RptQueries.not_Operator" initial=" " values="非 not/非 " )
- column=(type=char(1) update=yes updatewhereclause=yes name=left_icl dbname="u_RptQueries.left_icl" initial=" " values="( (/( " )
- column=(type=char(1) update=yes updatewhereclause=yes name=right_icl dbname="u_RptQueries.right_icl" initial=" " values=") )/) " )
- retrieve="PBSELECT( VERSION(400) TABLE(NAME=~"u_RptQueries~" ) COLUMN(NAME=~"u_RptQueries.rptid~") COLUMN(NAME=~"u_RptQueries.list_sort~") COLUMN(NAME=~"u_RptQueries.Column_number~") COLUMN(NAME=~"u_RptQueries.Column_DataType~") COLUMN(NAME=~"u_RptQueries.numeric_Operators~") COLUMN(NAME=~"u_RptQueries.string_Operators~") COLUMN(NAME=~"u_RptQueries.datetime_Operators~") COLUMN(NAME=~"u_RptQueries.Value~") COLUMN(NAME=~"u_RptQueries.datetime_Value~") COLUMN(NAME=~"u_RptQueries.Join_Operator~") COLUMN(NAME=~"u_RptQueries.not_Operator~") COLUMN(NAME=~"u_RptQueries.left_icl~") COLUMN(NAME=~"u_RptQueries.right_icl~")WHERE( EXP1 =~"u_RptQueries.rptid~" OP =~"=~" EXP2 =~":OBJ_RPTID~" ) ) ORDER(NAME=~"u_RptQueries.list_sort~" ASC=yes ) ARG(NAME = ~"OBJ_RPTID~" TYPE = number) " update="u_RptQueries" updatewhere=0 updatekeyinplace=no arguments=(("OBJ_RPTID", number)) )
- column(band=detail id=7 alignment="0" tabsequence=20 border="5" color="0" x="960" y="8" height="68" width="329" format="[general]" html.valueishtml="0" name=datetime_operators visible="1~tif( left( column_datatype, 4) = ~"date~" or left( column_datatype, 4) = ~"time~" , 1, 0)" ddlb.limit=0 ddlb.allowedit=no ddlb.case=any ddlb.vscrollbar=yes ddlb.useasborder=yes ddlb.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="33554431" )
- column(band=detail id=5 alignment="0" tabsequence=40 border="5" color="0" x="960" y="8" height="68" width="329" format="[general]" html.valueishtml="0" name=numeric_operators visible="1~tif( left( column_datatype, 4) not in ( ~"date~", ~"time~", ~"char~") and not isnull( column_datatype), 1, 0)" ddlb.limit=0 ddlb.allowedit=no ddlb.case=any ddlb.vscrollbar=yes ddlb.useasborder=yes ddlb.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="33554431" )
- column(band=detail id=6 alignment="0" tabsequence=30 border="5" color="0" x="960" y="8" height="68" width="329" format="[general]" html.valueishtml="0" name=string_operators visible="1~tIf( Left( column_datatype , 5) = ~"char(~" and not isnull( column_datatype ), 1, 0)" ddlb.limit=0 ddlb.allowedit=no ddlb.case=any ddlb.vscrollbar=yes ddlb.useasborder=yes ddlb.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="33554431" )
- column(band=detail id=13 alignment="0" tabsequence=100 border="0" color="0" x="1902" y="12" height="56" width="91" format="[general]" html.valueishtml="0" name=right_icl visible="1" checkbox.text=")" checkbox.on=")" checkbox.off=" " checkbox.lefttext=yes checkbox.scale=no checkbox.threed=yes font.face="宋体" font.height="-9" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="134217739" )
- column(band=detail id=3 alignment="1" tabsequence=10 border="5" color="0" x="361" y="8" height="68" width="576" format="[general]" html.valueishtml="0" name=column_number visible="1" dddw.name=ddd_columns dddw.displaycolumn=column_name dddw.datacolumn=column_number dddw.percentwidth=100 dddw.lines=0 dddw.limit=0 dddw.allowedit=yes dddw.useasborder=yes dddw.case=any dddw.imemode=0 dddw.vscrollbar=yes font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="33554431" )
- column(band=detail id=8 alignment="0" tabsequence=50 border="5" color="0" x="1307" y="8" height="68" width="576" format="[general]" html.valueishtml="0" name=value visible="1~tif( left( column_datatype, 4) not in ( ~"date~", ~"time~") and not isnull( column_datatype), 1, 0)" ddlb.limit=0 ddlb.allowedit=yes ddlb.case=any ddlb.vscrollbar=yes ddlb.useasborder=yes ddlb.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="33554431" )
- column(band=detail id=9 alignment="0" tabsequence=60 border="5" color="0" x="1307" y="8" height="68" width="576" format="" html.valueishtml="0" name=datetime_value visible="1~tif( left( column_datatype, 4) = ~"date~" or left( column_datatype, 4) = ~"time~" and not isnull( column_datatype ), 1, 0)" editmask.mask="yyyy-mm-dd " editmask.imemode=0 editmask.focusrectangle=no font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="33554431" )
- column(band=detail id=10 alignment="0" tabsequence=70 border="5" color="0" x="2011" y="8" height="68" width="238" format="[general]" html.valueishtml="0" name=join_operator visible="1" ddlb.limit=0 ddlb.allowedit=no ddlb.case=any ddlb.vscrollbar=yes ddlb.useasborder=yes ddlb.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="33554431" )
- column(band=detail id=1 alignment="0" tabsequence=32766 border="0" color="0" x="2409" y="4" height="76" width="183" format="[general]" html.valueishtml="0" name=rptid visible="1" edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0 font.face="Arial" font.height="-12" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
- column(band=detail id=2 alignment="0" tabsequence=32766 border="0" color="0" x="2601" y="4" height="76" width="128" format="[general]" html.valueishtml="0" name=list_sort visible="1" edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0 font.face="Arial" font.height="-12" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
- column(band=detail id=11 alignment="0" tabsequence=80 border="0" color="0" x="27" y="12" height="56" width="183" format="" html.valueishtml="0" name=not_operator visible="1" checkbox.text="非" checkbox.on="not" checkbox.off=" " checkbox.scale=no checkbox.threed=yes font.face="宋体" font.height="-9" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="134217739" )
- column(band=detail id=12 alignment="0" tabsequence=90 border="0" color="0" x="224" y="12" height="56" width="123" format="[general]" html.valueishtml="0" name=left_icl visible="1" checkbox.text="(" checkbox.on="(" checkbox.off=" " checkbox.scale=no checkbox.threed=yes font.face="宋体" font.height="-9" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="134217739" )
- htmltable(border="1" )
- htmlgen(clientevents="1" clientvalidation="1" clientcomputedfields="1" clientformatting="0" clientscriptable="0" generatejavascript="1" encodeselflinkargs="1" netscapelayers="0" )
- export.xml(headgroups="1" includewhitespace="0" metadatatype=0 savemetadata=0 )
- import.xml()
- export.pdf(method=0 distill.custompostscript="0" xslfop.print="0" )
|