首页 发现 帮助
登录
Neil
/
Q5
1
0
派生 0
文件 工单管理 0 合并请求 0 Wiki
目录树: c8934b408d
分支列表 标签列表
Q5
/
ws_objects
/
longjoe_report_uo.pbl.src
/
dw_rpt_relation.srd

dw_rpt_relation.srd 6.5 KB
文件历史 原始文件

12345678910111213141516171819202122232425262728293031 
  1. $PBExportHeader$dw_rpt_relation.srd
    2. 

  2. $PBExportComments$表的关联--数据窗口
    3. 

  3. release 6;
    4. 

  4. datawindow(units=0 timer_interval=0 color=80269524 processing=1 print.documentname="" print.orientation = 0 print.margin.left = 107 print.margin.right = 107 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 grid.lines=0 )
    5. 

  5. header(height=68 color="536870912" )
    6. 

  6. summary(height=0 color="536870912" )
    7. 

  7. footer(height=124 color="536870912" )
    8. 

  8. detail(height=80 color="536870912" )
    9. 

  9. table(column=(type=char(45) updatewhereclause=no name=s_col1 dbname="s_col1" initial="empty" )
    10. 

  10.  column=(type=char(12) updatewhereclause=no name=s_relation dbname="s_relation" initial="empty" values="=	=/*=	*=/=*	=*/(+)=	(+)=/<	</>	>/<=	<=/>=	>=/<>	<>/between	between/exists	exists/in	in/like	like/is	is/is not	is not/not between	not between/not exists	not exists/not in	not in/not like	not like/" )
    11. 

  11.  column=(type=char(45) updatewhereclause=no name=s_col2 dbname="s_col2" initial="empty" )
    12. 

  12.  column=(type=char(8) updatewhereclause=no name=s_label dbname="s_label" initial="empty" values="并且	 and /或者	 or /" )
    13. 

  13.  column=(type=char(6) updatewhereclause=no name=s_zkh dbname="s_zkh" initial="empty" values=" 	 /(	(/((	((/(((	(((/" )
    14. 

  14.  column=(type=char(6) updatewhereclause=no name=s_ykh dbname="s_ykh" initial="empty" values=" 	 /)	)/))	))/)))	)))/" )
    15. 

  15.  )
    16. 

  16. text(band=background alignment="0" text="关系符 *= 表示左边的表有记录而右边的表不一定有记录,即rows from table1 that have no table2"border="0" color="16711680" x="421" y="932" height="52" width="2450"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="80269524" )
    17. 

  17. text(band=background alignment="0" text="关系符 =* 表示右边的表有记录而左边的表不一定有记录,即rows from table2 that have no table1"border="0" color="16711680" x="421" y="996" height="52" width="2450"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="80269524" )
    18. 

  18. text(band=header alignment="2" text="（"border="6" color="0" x="9" y="8" height="52" width="151"  name=s_zkh_t  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="80269524" )
    19. 

  19. text(band=header alignment="2" text="表名.字段"border="6" color="0" x="169" y="8" height="52" width="1143"  name=s_col1_t  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="80269524" )
    20. 

  20. text(band=header alignment="2" text="关系符"border="6" color="0" x="1321" y="8" height="52" width="261"  name=s_relation_t  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="80269524" )
    21. 

  21. text(band=header alignment="2" text="表名.字段/值"border="6" color="0" x="1591" y="8" height="52" width="1143"  name=s_field2_t  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="80269524" )
    22. 

  22. text(band=header alignment="2" text="）"border="6" color="0" x="2743" y="8" height="52" width="151"  name=s_ykh_t  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="80269524" )
    23. 

  23. text(band=header alignment="2" text="逻辑符"border="6" color="0" x="2903" y="8" height="52" width="165"  name=s_label_t  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="80269524" )
    24. 

  24. button(band=detail text="X"filename=""action="0" border="0" color="255" x="3086" y="0" height="68" width="55" vtextalign="0" htextalign="0"  name=rowclear  font.face="宋体" font.height="-8" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="80269524" )
    25. 

  25. column(band=detail id=5 alignment="2" tabsequence=10 border="5" color="0" x="9" y="8" height="60" width="151" format="[general]"  name=s_zkh ddlb.limit=0 ddlb.allowedit=no ddlb.case=any  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
    26. 

  26. column(band=detail id=1 alignment="0" tabsequence=20 border="5" color="0" x="169" y="8" height="60" width="1143" format="[general]"  name=s_col1 dddw.name=dw_rpt_field_drop dddw.displaycolumn=ctag2 dddw.datacolumn=cdbname dddw.percentwidth=100 dddw.lines=0 dddw.limit=0 dddw.allowedit=yes dddw.useasborder=no dddw.case=any dddw.autohscroll=yes dddw.vscrollbar=yes  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
    27. 

  27. column(band=detail id=2 alignment="0" tabsequence=30 border="5" color="0" x="1321" y="8" height="60" width="261" format="[general]"  name=s_relation ddlb.limit=0 ddlb.allowedit=no ddlb.case=any ddlb.vscrollbar=yes  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
    28. 

  28. column(band=detail id=3 alignment="0" tabsequence=40 border="5" color="0" x="1591" y="8" height="60" width="1143" format="[general]"  name=s_col2 dddw.name=dw_rpt_field_drop dddw.displaycolumn=ctag2 dddw.datacolumn=cdbname dddw.percentwidth=100 dddw.lines=0 dddw.limit=0 dddw.allowedit=yes dddw.useasborder=no dddw.case=any dddw.autohscroll=yes dddw.vscrollbar=yes  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
    29. 

  29. column(band=detail id=6 alignment="2" tabsequence=50 border="5" color="0" x="2743" y="8" height="60" width="151" format="[general]"  name=s_ykh ddlb.limit=0 ddlb.allowedit=no ddlb.case=any  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
    30. 

  30. column(band=detail id=4 alignment="0" tabsequence=60 border="5" color="0" x="2903" y="8" height="60" width="165" format="[general]"  name=s_label ddlb.limit=0 ddlb.allowedit=no ddlb.case=any  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
    31. 

  31. htmltable(border="1" cellpadding="0" cellspacing="0" generatecss="no" nowrap="yes")
    32.