eaglass.sql

文件传输源码pb9－－高级winsokt编程

SET IDENTITY_INSERT [cw_feiyongbiao] OFF

CREATE TABLE [dwsyntax] (
	[id] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
	[reportdw] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[basedw] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[cbasedw] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[creportdw] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[maker] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[make_date] [datetime] NULL ,
	[dwsyntax] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	CONSTRAINT [PK_dwsyntax] PRIMARY KEY  CLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO




DELETE FROM [dwsyntax]
GO

SET IDENTITY_INSERT [dwsyntax] ON
GO


INSERT INTO [dwsyntax] ( id, reportdw, basedw, cbasedw, creportdw, maker, make_date, dwsyntax) VALUES (1,'d_gongyingshang_lb','d_gongyingshang_lb',Null,Null,Null,Null,'release 9;
datawindow ( units=0 timer_interval=60000 color=1073741824 processing=0 pointer=""  print.printername=""  print.documentname=""  print.orientation=1 print.margin.left=220 print.margin.right=110 print.margin.top=96 print.margin.bottom=96 print.paper.size=0 print.paper.source=0 print.canusedefaultprinter=yes selected.mouse=no)
header(height=288 color="32369854" )
summary(height=84 color="134217752" )
footer(height=4 color="67108864" )
detail(height=92 color="67108864" )
table(column=(type=char(20) update=yes updatewhereclause=yes name=jsm dbname="gongyingshang.jsm"  )
column=(type=char(50) update=yes updatewhereclause=yes name=dizhi dbname="gongyingshang.dizhi"  )
column=(type=char(20) update=yes updatewhereclause=yes name=diqu dbname="gongyingshang.diqu"  )
column=(type=char(10) update=yes updatewhereclause=yes name=youbian dbname="gongyingshang.youbian"  )
column=(type=char(20) update=yes updatewhereclause=yes name=dh dbname="gongyingshang.dh"  )
column=(type=char(20) update=yes updatewhereclause=yes name=chuanzehen dbname="gongyingshang.chuanzehen"  )
column=(type=char(10) update=yes updatewhereclause=yes name=zhuangtai dbname="gongyingshang.zhuangtai"  )
column=(type=char(20) update=yes updatewhereclause=yes name=didian dbname="gongyingshang.didian"  )
column=(type=char(20) update=yes updatewhereclause=yes name=faren dbname="gongyingshang.faren"  )
column=(type=char(20) update=yes updatewhereclause=yes name=lxr dbname="gongyingshang.lxr"  )
column=(type=char(20) update=yes updatewhereclause=yes name=moshi dbname="gongyingshang.moshi"  )
column=(type=char(20) update=yes updatewhereclause=yes name=shuihao dbname="gongyingshang.shuihao"  )
column=(type=char(20) update=yes updatewhereclause=yes name=zhanghao dbname="gongyingshang.zhanghao"  )
column=(type=char(50) update=yes updatewhereclause=yes name=beizhu dbname="gongyingshang.beizhu"  )
column=(type=char(20) key=yes update=yes updatewhereclause=yes name=id dbname="gongyingshang.id"  )
column=(type=char(40) update=yes updatewhereclause=yes name=name dbname="gongyingshang.name"  )
column=(type=decimal(4) updatewhereclause=yes name=qkje dbname="gongyingshang.qkje"  )
 retrieve="PBSELECT( VERSION(400) TABLE(NAME=~"gongyingshang~" ) COLUMN(NAME=~"gongyingshang.jsm~") COLUMN(NAME=~"gongyingshang.dizhi~") COLUMN(NAME=~"gongyingshang.diqu~") COLUMN(NAME=~"gongyingshang.youbian~") COLUMN(NAME=~"gongyingshang.dh~") COLUMN(NAME=~"gongyingshang.chuanzehen~") COLUMN(NAME=~"gongyingshang.zhuangtai~") COLUMN(NAME=~"gongyingshang.didian~") COLUMN(NAME=~"gongyingshang.faren~") COLUMN(NAME=~"gongyingshang.lxr~") COLUMN(NAME=~"gongyingshang.moshi~") COLUMN(NAME=~"gongyingshang.shuihao~") COLUMN(NAME=~"gongyingshang.zhanghao~") COLUMN(NAME=~"gongyingshang.beizhu~") COLUMN(NAME=~"gongyingshang.id~") COLUMN(NAME=~"gongyingshang.name~") COLUMN(NAME=~"gongyingshang.qkje~")) ORDER(NAME=~"gongyingshang.diqu~" ASC=yes )  ORDER(NAME=~"gongyingshang.jsm~" ASC=yes ) "
  update="gongyingshang" updatewhere=1 updatekeyinplace=no
 )
text(name=faren_t visible="0" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="33554432" alignment="2" border="0" x="4946" y="8" height="60" width="672" text="Faren" )
text(name=lxr_t visible="0" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="33554432" alignment="2" border="0" x="5627" y="8" height="60" width="672" text="Lxr" )
text(name=moshi_t visible="0" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="33554432" alignment="2" border="0" x="6309" y="8" height="60" width="672" text="Moshi" )
text(name=shuihao_t visible="0" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="33554432" alignment="2" border="0" x="6990" y="8" height="60" width="672" text="Shuihao" )
text(name=zhanghao_t visible="0" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="33554432" alignment="2" border="0" x="7671" y="8" height="60" width="672" text="Zhanghao" )
text(name=beizhu_t visible="0" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="33554432" alignment="2" border="0" x="8352" y="8" height="60" width="1632" text="Beizhu" )
text(name=dizhi_t visible="1" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" background.mode="1" background.color="8421504" color="33554432" alignment="2" border="0" x="1815" y="192" height="60" width="955" text="地址" )
text(name=youbian_t visible="1" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" background.mode="1" background.color="8421504" color="33554432" alignment="2" border="0" x="2770" y="192" height="60" width="247" text="邮编" )
text(name=dh_t visible="1" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" background.mode="1" background.color="8421504" color="33554432" alignment="2" border="0" x="3040" y="192" height="60" width="384" text="电话" )
text(name=chuanzehen_t visible="1" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" background.mode="1" background.color="8421504" color="33554432" alignment="2" border="0" x="3433" y="192" height="60" width="338" text="传真" )
text(name=zhuangtai_t visible="1" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" background.mode="1" background.color="8421504" color="33554432" alignment="2" border="0" x="3785" y="192" height="60" width="128" text="状态" )
text(name=qkje_t visible="1" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" background.mode="1" background.color="553648127" color="33554432" alignment="1" border="0" x="3918" y="200" height="60" width="352" text="欠款余额" )
text(name=name_t visible="1" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" background.mode="1" background.color="8421504" color="33554432" alignment="2" border="0" x="855" y="192" height="60" width="942" text="供应商名称" )
text(name=jsm_t visible="1" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" background.mode="1" background.color="8421504" color="33554432" alignment="2" border="0" x="645" y="192" height="60" width="201" text="检索码" )
text(name=id_t visible="1" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" background.mode="1" background.color="8421504" color="33554432" alignment="2" border="0" x="375" y="192" height="60" width="261" text="编号" )
text(name=diqu_t visible="1" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" background.mode="1" background.color="8421504" color="33554432" alignment="2" border="0" x="183" y="192" height="60" width="183" text="地区" )
text(name=t_1 visible="1" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" background.mode="1" background.color="8421504" color="33554432" alignment="2" border="0" x="9" y="192" height="60" width="165" text="序号" )
text(name=didian_t visible="0" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" background.mode="1" background.color="8421504" color="33554432" alignment="2" border="0" x="3895" y="192" height="60" width="672" text="Didian" )
text(name=t_bt visible="1" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-16" font.pitch="2" font.weight="400" background.mode="2" background.color="1073741824" color="33554432" alignment="2" border="0" x="5" y="12" height="88" width="4640" text="供货商目录表" )
compute(name=sj visible="0" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" background.mode="2" background.color="1073741824" color="33554432" x="503" y="68" height="64" width="1317" format="[GENERAL]" expression="''时间:''+string(today())" alignment="0" border="0" crosstab.repeat=no )
compute(name=compute_1 visible="1" band=summary font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" background.mode="1" background.color="553648127" color="33554432" x="850" y="8" height="76" width="942" format="[GENERAL]" expression="count( id )" alignment="2" border="0" crosstab.repeat=no )
compute(name=compute_3 visible="1" band=summary font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" background.mode="1" background.color="553648127" color="33554432" x="4270" y="80" height="60" width="352" format="###,###.00" expression="sum(qkje for all)" alignment="1" border="0" crosstab.repeat=no )
column(name=faren visible="0" band=detail id=9 x="4521" y="16" height="88" width="672" color="33554432" border="0" alignment="0" format="[general]" edit.focusrectangle=no edit.autohscroll=yes edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=20 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="1" background.color="536870912" font.charset="134" font.face="宋体" font.family="2" font.height="-10" font.pitch="2" font.weight="400" tabsequence=110 )
column(name=lxr visible="0" band=detail id=10 x="5202" y="16" height="88" width="672" color="33554432" border="0" alignment="0" format="[general]" edit.focusrectangle=no edit.autohscroll=yes edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=20 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="1" background.color="536870912" font.charset="134" font.face="宋体" font.family="2" font.height="-10" font.pitch="2" font.weight="400" tabsequence=120 )
column(name=moshi visible="0" band=detail id=11 x="5884" y="16" height="88" width="672" color="33554432" border="0" alignment="0" format="[general]" edit.focusrectangle=no edit.autohscroll=yes edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=20 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="1" background.color="536870912" font.charset="134" font.face="宋体" font.family="2" font.height="-10" font.pitch="2" font.weight="400" tabsequence=130 )
column(name=shuihao visible="0" band=detail id=12 x="6565" y="16" height="88" width="672" color="33554432" border="0" alignment="0" format="[general]" edit.focusrectangle=no edit.autohscroll=yes edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=20 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="1" background.color="536870912" font.charset="134" font.face="宋体" font.family="2" font.height="-10" font.pitch="2" font.weight="400" tabsequence=140 )
column(name=zhanghao visible="0" band=detail id=13 x="7246" y="16" height="88" width="672" color="33554432" border="0" alignment="0" format="[general]" edit.focusrectangle=no edit.autohscroll=yes edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=20 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="1" background.color="536870912" font.charset="134" font.face="宋体" font.family="2" font.height="-10" font.pitch="2" font.weight="400" tabsequence=150 )
column(name=beizhu visible="0" band=detail id=14 x="7927" y="16" height="88" width="1632" color="33554432" border="0" alignment="0" format="[general]" edit.focusrectangle=no edit.autohscroll=yes edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=50 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="1" background.color="536870912" font.charset="134" font.face="宋体" font.family="2" font.height="-10" font.pitch="2" font.weight="400" tabsequence=160 )
column(name=didian visible="0" band=detail id=8 x="3840" y="40" height="56" width="672" color="33554432" border="0" alignment="0" format="[general]" edit.focusrectangle=no edit.autohscroll=yes edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=20 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="1" background.color="536870912" font.charset="134" font.face="宋体" font.family="2" font.height="-10" font.pitch="2" font.weight="400" tabsequence=100 )
column(name=chuanzehen visible="1" band=detail id=6 x="3378" y="36" height="56" width="338" color="33554432" border="0" alignment="0" format="[general]" edit.focusrectangle=no edit.autohscroll=yes edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=20 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="1" background.color="536870912" font.charset="134" font.face="宋体" font.family="2" font.height="-10" font.pitch="2" font.weight="400" tabsequence=70 )
column(name=zhuangtai visible="1" band=detail id=7 x="3726" y="36" height="56" width="128" color="33554432" border="0" alignment="0" format="[general]" edit.focusrectangle=no edit.autohscroll=yes edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=10 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="1" background.color="536870912" font.charset="134" font.face="宋体" font.family="2" font.height="-10" font.pitch="2" font.weight="400" tabsequence=80 )
column(name=qkje visible="1" band=detail id=17 x="3982" y="24" height="56" width="352" color="33554432" border="0" alignment="1" format="###,###.00" edit.name="###,###.00" editmask.focusrectangle=no editmask.autoskip=no editmask.required=no editmask.readonly=no editmask.codetable=no editmask.spin=no editmask.mask="###,###.00" editmask.imemode=0 criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="1" background.color="553648127" font.charset="134" font.face="宋体" font.family="2" font.height="-10" font.pitch="2" font.weight="400" tabsequence=90 )
column(name=id visible="1" band=detail id=15 x="375" y="28" height="56" width="261" color="33554432" border="0" alignment="2" format="[general]" edit.focusrectangle=no edit.autohscroll=yes edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=0 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="1" background.color="536870912" font.charset="134" font.face="宋体" font.family="2" font.height="-10" font.pitch="2" font.weight="400" tabsequence=0 )
column(name=jsm visible="1" band=detail id=1 x="645" y="28" height="56" width="201" color="33554432" border="0" alignment="0" format="[general]" edit.focusrectangle=no edit.autohscroll=yes edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=20 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="1" background.color="536870912" font.charset="134" font.face="宋体" font.family="2" font.height="-10" font.pitch="2" font.weight="400" tabsequence=20 )
column(name=name visible="1" band=detail id=16 x="855" y="28" height="56" width="942" color="33554432" border="0" alignment="0" format="[general]" edit.focusrectangle=no edit.autohscroll=yes edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=20 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="1" background.color="536870912" font.charset="134" font.face="宋体" font.family="2" font.height="-10" font.pitch="2" font.weight="400" tabsequence=30 )
column(name=dizhi visible="1" band=detail id=2 x="1806" y="28" height="56" width="955" color="33554432" border="0" alignment="0" format="[general]" edit.focusrectangle=no edit.autohscroll=yes edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=50 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="1" background.color="536870912" font.charset="134" font.face="宋体" font.family="2" font.height="-10" font.pitch="2" font.weight="400" tabsequence=40 )
column(name=youbian visible="1" band=detail id=4 x="2770" y="28" height="56" width="247" color="33554432" border="0" alignment="0" format="[general]" edit.focusrectangle=no edit.autohscroll=yes edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=10 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="1" background.color="536870912" font.charset="134" font.face="宋体" font.family="2" font.height="-10" font.pitch="2" font.weight="400" tabsequence=50 )
column(name=dh visible="1" band=detail id=5 x="3085" y="12" height="56" width="384" color="33554432" border="0" alignment="0" format="[general]" edit.focusrectangle=no edit.autohscroll=yes edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=20 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="1" background.color="536870912" font.charset="134" font.face="宋体" font.family="2" font.height="-10" font.pitch="2" font.weight="400" tabsequence=60 )
column(name=diqu visible="1" band=detail id=3 x="183" y="28" height="56" width="183" color="33554432" border="0" alignment="0" format="[general]" edit.autohscroll=no edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=0 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="1" background.color="536870912" font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" tabsequence=10 )
compute(name=compute_2 visible="1" band=detail font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" background.mode="2" background.color="1073741824" color="33554432" x="9" y="28" height="56" width="165" format="[GENERAL]" expression="getrow()" alignment="2" border="0" crosstab.repeat=no )
htmltable(border="1" )
htmlgen(clientComputedFields="1" clientEvents="1" clientFormatting="0" clientScriptable="0" clientValidation="1" generateJavaScript="1" netscapeLayers="0" netscapelayers="0" encodeSelfLinkArgs="1" )
export.xml(headGroups="1" includewhitespace="0" metadatatype=0 savemetadata=0 )
import.xml()
export.pdf(method=0distill.customPostScript="0" xslfop.print="0" )
')
INSERT INTO [dwsyntax] ( id, reportdw, basedw, cbasedw, creportdw, maker, make_date, dwsyntax) VALUES (2,'d_yanguangdan_bj0','d_yanguangdan_bj0',Null,Null,Null,Null,'release 9;
datawindow ( units=0 timer_interval=0 color=16777215 processing=0 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.size=0 print.paper.source=0 print.canusedefaultprinter=yes selected.mouse=no)
header(height=0 )
summary(height=0 color="536870912" )
footer(height=0 color="536870912" )
detail(height=712 color="536870912" )
table(column=(type=datetime update=yes updatewhereclause=yes name=验光日期 dbname="验光单.验光日期"  )
column=(type=char(10) updatewhereclause=yes name=yuan dbname="验光单.yuan" 
 values="近用	近用/远用	远用/"  )
column=(type=char(10) update=yes updatewhereclause=yes name=验光师 dbname="验光单.验光师" 
 values=""  )
column=(type=char(20) update=yes updatewhereclause=yes name=说明 dbname="验光单.说明"  )
column=(type=char(20) update=yes updatewhereclause=yes name=sjbh dbname="验光单.顾客id" 
 values=""  )
column=(type=char(12) update=yes updatewhereclause=yes name=验光单编号 dbname="验光单.验光单编号"  )
 retrieve="PBSELECT( VERSION(400) TABLE(NAME=~"验光单~" ) COLUMN(NAME=~"验光单.验光日期~") COLUMN(NAME=~"验光单.yuan~") COLUMN(NAME=~"验光单.验光师~") COLUMN(NAME=~"验光单.说明~") COLUMN(NAME=~"验光单.顾客id~") COLUMN(NAME=~"验光单.验光单编号~")WHERE(    EXP1 =~"验光单.验光单编号~"   OP =~"=~"    EXP2 =~":xid~" ) ) ARG(NAME = ~"xid~" TYPE = string) "
  arguments=(("xid", string))
)
text(name=t_bt visible="1" band=detail font.charset="134" font.face="宋体" font.family="0" font.height="-16" font.pitch="2" font.weight="700" background.mode="1" background.color="536870912" color="134217729" alignment="2" border="0" x="23" y="8" height="96" width="2432" text="大明眼镜验光单" )
column(name=验光日期 visible="1" band=detail id=1 x="969" y="124" height="72" width="407" color="33554432" border="0" alignment="0" format="yyyy-mm-dd" editmask.focusrectangle=no editmask.autoskip=no editmask.required=no editmask.readonly=no editmask.codetable=no editmask.spin=yes editmask.spinincr=0 editmask.mask="yyyy-mm-dd" editmask.imemode=0 criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="1" background.color="536870912" font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" tabsequence=10 )
column(name=sjbh visible="1" band=detail id=5 x="293" y="216" height="60" width="809" color="33554432" border="0" alignment="0" format="[general]" dddw.allowedit=no dddw.autohscroll=no dddw.autoretrieve=yes dddw.useasborder=no dddw.datacolumn=id dddw.displaycolumn=name dddw.hscrollbar=no dddw.hsplitscroll=no dddw.imemode=0 dddw.limit=0 dddw.name=d_khxx_select dddw.nilisnull=no dddw.percentwidth=0 dddw.required=no dddw.showlist=no dddw.vscrollbar=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="1" background.color="536870912" font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" tabsequence=0 )
text(name=顾客id_t visible="1" band=detail font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="33554432" alignment="1" border="0" x="23" y="216" height="60" width="270" text="顾客姓名:" )
text(name=验光师_t visible="1" band=detail font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="33554432" alignment="1" border="0" x="1815" y="216" height="60" width="379" text="验光师:" )
text(name=验光单编号_t visible="1" band=detail font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="33554432" alignment="1" border="0" x="1216" y="220" height="60" width="334" text="验光单编号:" )
column(name=验光单编号 visible="1" band=detail id=6 x="1568" y="220" height="60" width="398" color="33554432" border="0" alignment="0" format="[general]" edit.focusrectangle=no edit.autohscroll=yes edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=24 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="1" background.color="536870912" font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" tabsequence=0 )
column(name=验光师 visible="1" band=detail id=3 x="2213" y="216" height="60" width="398" color="33554432" border="5" alignment="0" format="[general]" dddw.allowedit=yes dddw.autohscroll=no dddw.autoretrieve=yes dddw.useasborder=no dddw.datacolumn=gh dddw.displaycolumn=name dddw.hscrollbar=no dddw.hsplitscroll=no dddw.imemode=0 dddw.limit=0 dddw.name=d_fuzhu_yuangong_lb dddw.nilisnull=no dddw.percentwidth=130 dddw.required=no dddw.showlist=no dddw.vscrollbar=yes criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="2" background.color="32369854" font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" tabsequence=30 )
column(name=yuan visible="1" band=detail id=2 x="2213" y="140" height="64" width="398" color="33554432" border="5" alignment="0" format="[general]" ddlb.allowedit=no ddlb.autohscroll=no ddlb.imemode=0 ddlb.limit=0 ddlb.showlist=no ddlb.sorted=no ddlb.useasborder=no ddlb.vscrollbar=no ddlb.nilisnull=no ddlb.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="2" background.color="32369854" font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" tabsequence=20 )
text(name=t_1 visible="1" band=detail font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="33554432" alignment="1" border="0" x="1810" y="144" height="60" width="379" text="用途:" )
text(name=t_2 visible="1" band=detail font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="33554432" alignment="1" border="0" x="0" y="636" height="60" width="178" text="备注:" )
column(name=说明 visible="1" band=detail id=4 x="192" y="636" height="64" width="2437" color="33554432" border="0" alignment="0" format="[general]" edit.autohscroll=no edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=20 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="2" background.color="32369854" font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" tabsequence=40 )
htmltable(border="1" )
htmlgen(clientComputedFields="1" clientEvents="1" clientFormatting="0" clientScriptable="0" clientValidation="1" generateJavaScript="1" netscapeLayers="0" netscapelayers="0" encodeSelfLinkArgs="1" )
export.xml(headGroups="1" includewhitespace="0" metadatatype=0 savemetadata=0 )
import.xml()
export.pdf(method=0distill.customPostScript="0" xslfop.print="0" )
')
INSERT INTO [dwsyntax] ( id, reportdw, basedw, cbasedw, creportdw, maker, make_date, dwsyntax) VALUES (3,'d_yanguangdan_bj1','d_yanguangdan_bj1',Null,Null,Null,Null,'release 9;
datawindow ( units=0 timer_interval=0 color=31714529 processing=1 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.size=0 print.paper.source=0 print.canusedefaultprinter=yes grid.lines=0 selected.mouse=yes)
header(height=84 color="31714529" )
summary(height=0 color="134217752" )
footer(height=0 color="536870912" )
detail(height=92 color="32369854" )
table(column=(type=char(10) update=yes updatewhereclause=yes name=左 dbname="验光单.左"  )
column=(type=char(10) update=yes updatewhereclause=yes name=球镜 dbname="验光单.球镜"  )
column=(type=char(10) update=yes updatewhereclause=yes name=柱镜 dbname="验光单.柱镜"  )
column=(type=char(10) update=yes updatewhereclause=yes name=轴向 dbname="验光单.轴向"  )
column=(type=char(10) update=yes updatewhereclause=yes name=瞳距mm dbname="验光单.瞳距mm"  )
column=(type=char(10) update=yes updatewhereclause=yes name=纠正视力 dbname="验光单.纠正视力"  )
column=(type=char(12