同样的数据库，在VFP中根本就没有延时。。。为什么呢？？？应该怎么办呢？？？？帮帮我吧。。。。。谢谢。。。
注：我是想把单位用VFP编的管理系统改用PB重编一下。。。。谢谢大家。帮帮忙.在线等待。
9 个解决方案
#1
retrieve as needed 选中即可
#2
谢谢，，，，可是我要用于统计的话，该怎么办呢？
#3
To:morningdew(晓峰)
你跑哪去了？重装了ASA，刚看完，把下面的导进去看一看：
$PBExportHeader$w_id.srw
$PBExportComments$用户增、删、改窗口
forward
global type w_id from window
end type
type dw_id from datawindow within w_id
end type
end forward
global type w_id from window
integer width = 3497
integer height = 1876
boolean titlebar = true
string title = "用户增、删、改"
boolean controlmenu = true
boolean minbox = true
boolean maxbox = true
boolean resizable = true
long backcolor = 15793151
string icon = "AppIcon!"
event ue_postopen ( )
dw_id dw_id
end type
global w_id w_id
event ue_postopen();//检索数据
dw_id.retrieve()
end event
on w_id.create
this.dw_id=create dw_id
this.Control[]={this.dw_id}
end on
on w_id.destroy
destroy(this.dw_id)
end on
event open;dw_id.settransobject(sqlca)
this.post event ue_postopen()
end event
type dw_id from datawindow within w_id
integer x = 96
integer y = 96
integer width = 3305
integer height = 1416
integer taborder = 10
string title = "none"
string dataobject = "d_id"
boolean hscrollbar = true
boolean vscrollbar = true
boolean livescroll = true
borderstyle borderstyle = stylelowered!
end type
你跑哪去了？重装了ASA，刚看完，把下面的导进去看一看：
$PBExportHeader$w_id.srw
$PBExportComments$用户增、删、改窗口
forward
global type w_id from window
end type
type dw_id from datawindow within w_id
end type
end forward
global type w_id from window
integer width = 3497
integer height = 1876
boolean titlebar = true
string title = "用户增、删、改"
boolean controlmenu = true
boolean minbox = true
boolean maxbox = true
boolean resizable = true
long backcolor = 15793151
string icon = "AppIcon!"
event ue_postopen ( )
dw_id dw_id
end type
global w_id w_id
event ue_postopen();//检索数据
dw_id.retrieve()
end event
on w_id.create
this.dw_id=create dw_id
this.Control[]={this.dw_id}
end on
on w_id.destroy
destroy(this.dw_id)
end on
event open;dw_id.settransobject(sqlca)
this.post event ue_postopen()
end event
type dw_id from datawindow within w_id
integer x = 96
integer y = 96
integer width = 3305
integer height = 1416
integer taborder = 10
string title = "none"
string dataobject = "d_id"
boolean hscrollbar = true
boolean vscrollbar = true
boolean livescroll = true
borderstyle borderstyle = stylelowered!
end type
#4
$PBExportHeader$d_id.srd
$PBExportComments$用户信息
release 8;
datawindow(units=0 timer_interval=0 color=1073741824 processing=1 HTMLDW=no 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.prompt=no print.buttons=no print.preview.buttons=no grid.lines=0 )
header(height=68 color="536870912" )
summary(height=0 color="536870912" )
footer(height=0 color="536870912" )
detail(height=84 color="536870912" )
table(column=(type=char(10) update=yes updatewhereclause=yes key=yes name=用户编号 dbname="maindata.用户编号" )
column=(type=char(20) update=yes updatewhereclause=yes name=用户名 dbname="maindata.用户名" )
column=(type=char(20) update=yes updatewhereclause=yes name=住址 dbname="maindata.住址" )
column=(type=char(2) update=yes updatewhereclause=yes name=收费所 dbname="maindata.收费所" )
column=(type=char(8) update=yes updatewhereclause=yes name=抄表员姓名 dbname="maindata.抄表员姓名" )
column=(type=char(8) update=yes updatewhereclause=yes name=管理员姓名 dbname="maindata.管理员姓名" )
column=(type=char(3) update=yes updatewhereclause=yes name=用水类别 dbname="maindata.用水类别" )
column=(type=decimal(2) update=yes updatewhereclause=yes name=定量标准 dbname="maindata.定量标准" )
column=(type=decimal(2) update=yes updatewhereclause=yes name=人·物数 dbname="maindata.人·物数" )
column=(type=decimal(2) update=yes updatewhereclause=yes name=单价 dbname="maindata.单价" )
column=(type=decimal(2) update=yes updatewhereclause=yes name=加压费 dbname="maindata.加压费" )
column=(type=decimal(2) update=yes updatewhereclause=yes name=水表管理费 dbname="maindata.水表管理费" )
column=(type=decimal(2) update=yes updatewhereclause=yes name=附加费 dbname="maindata.附加费" )
column=(type=char(32767) update=yes updatewhereclause=yes name=备注 dbname="maindata.备注" )
retrieve="PBSELECT(TABLE(NAME=~"maindata~") COLUMN(NAME=~"maindata.用户编号~")COLUMN(NAME=~"maindata.用户名~")COLUMN(NAME=~"maindata.住址~")COLUMN(NAME=~"maindata.收费所~")COLUMN(NAME=~"maindata.抄表员姓名~")COLUMN(NAME=~"maindata.管理员姓名~")COLUMN(NAME=~"maindata.用水类别~")COLUMN(NAME=~"maindata.定量标准~")COLUMN(NAME=~"maindata.人·物数~")COLUMN(NAME=~"maindata.单价~")COLUMN(NAME=~"maindata.加压费~")COLUMN(NAME=~"maindata.水表管理费~")COLUMN(NAME=~"maindata.附加费~")COLUMN(NAME=~"maindata.备注~"))ORDER(NAME = ~"maindata.用户编号~" ASC = yes) " update="maindata" updatewhere=1 updatekeyinplace=no retrieve.asneeded=yes )
text(band=header alignment="2" text="用户编号" border="0" color="33554432" x="9" y="8" height="76" width="352" html.valueishtml="0" name=用户编号_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="12639424" )
text(band=header alignment="2" text="用户名" border="0" color="33554432" x="370" y="8" height="76" width="672" html.valueishtml="0" name=用户名_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="12639424" )
text(band=header alignment="2" text="住址" border="0" color="33554432" x="1051" y="8" height="76" width="672" html.valueishtml="0" name=住址_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="12639424" )
text(band=header alignment="2" text="收费所" border="0" color="33554432" x="1733" y="8" height="76" width="261" html.valueishtml="0" name=收费所_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="12639424" )
text(band=header alignment="2" text="抄表员姓名" border="0" color="33554432" x="2002" y="8" height="76" width="393" html.valueishtml="0" name=抄表员姓名_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="12639424" )
text(band=header alignment="2" text="管理员姓名" border="0" color="33554432" x="2405" y="8" height="76" width="430" html.valueishtml="0" name=管理员姓名_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="12639424" )
text(band=header alignment="2" text="用水类别" border="0" color="33554432" x="2843" y="8" height="76" width="384" html.valueishtml="0" name=用水类别_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="12639424" )
text(band=header alignment="2" text="定量标准" border="0" color="33554432" x="3237" y="8" height="76" width="384" html.valueishtml="0" name=定量标准_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="12639424" )
text(band=header alignment="2" text="人·物数" border="0" color="33554432" x="3630" y="8" height="76" width="384" html.valueishtml="0" name=人·物数_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="12639424" )
text(band=header alignment="2" text="单价" border="0" color="33554432" x="4023" y="8" height="76" width="384" html.valueishtml="0" name=单价_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="12639424" )
text(band=header alignment="2" text="加压费" border="0" color="33554432" x="4416" y="8" height="76" width="384" html.valueishtml="0" name=加压费_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="12639424" )
text(band=header alignment="2" text="水表管理费" border="0" color="33554432" x="4809" y="8" height="76" width="384" html.valueishtml="0" name=水表管理费_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="12639424" )
text(band=header alignment="2" text="附加费" border="0" color="33554432" x="5202" y="8" height="76" width="384" html.valueishtml="0" name=附加费_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="12639424" )
text(band=header alignment="2" text="备注" border="0" color="33554432" x="5595" y="8" height="76" width="1161" html.valueishtml="0" name=备注_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="12639424" )
column(band=detail id=1 alignment="0" tabsequence=10 border="0" color="32768" x="9" y="16" height="56" width="352" format="[general]" html.valueishtml="0" name=用户编号 visible="1" edit.limit=10 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=2 alignment="0" tabsequence=20 border="0" color="33554432" x="370" y="16" height="56" width="672"
$PBExportComments$用户信息
release 8;
datawindow(units=0 timer_interval=0 color=1073741824 processing=1 HTMLDW=no 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.prompt=no print.buttons=no print.preview.buttons=no grid.lines=0 )
header(height=68 color="536870912" )
summary(height=0 color="536870912" )
footer(height=0 color="536870912" )
detail(height=84 color="536870912" )
table(column=(type=char(10) update=yes updatewhereclause=yes key=yes name=用户编号 dbname="maindata.用户编号" )
column=(type=char(20) update=yes updatewhereclause=yes name=用户名 dbname="maindata.用户名" )
column=(type=char(20) update=yes updatewhereclause=yes name=住址 dbname="maindata.住址" )
column=(type=char(2) update=yes updatewhereclause=yes name=收费所 dbname="maindata.收费所" )
column=(type=char(8) update=yes updatewhereclause=yes name=抄表员姓名 dbname="maindata.抄表员姓名" )
column=(type=char(8) update=yes updatewhereclause=yes name=管理员姓名 dbname="maindata.管理员姓名" )
column=(type=char(3) update=yes updatewhereclause=yes name=用水类别 dbname="maindata.用水类别" )
column=(type=decimal(2) update=yes updatewhereclause=yes name=定量标准 dbname="maindata.定量标准" )
column=(type=decimal(2) update=yes updatewhereclause=yes name=人·物数 dbname="maindata.人·物数" )
column=(type=decimal(2) update=yes updatewhereclause=yes name=单价 dbname="maindata.单价" )
column=(type=decimal(2) update=yes updatewhereclause=yes name=加压费 dbname="maindata.加压费" )
column=(type=decimal(2) update=yes updatewhereclause=yes name=水表管理费 dbname="maindata.水表管理费" )
column=(type=decimal(2) update=yes updatewhereclause=yes name=附加费 dbname="maindata.附加费" )
column=(type=char(32767) update=yes updatewhereclause=yes name=备注 dbname="maindata.备注" )
retrieve="PBSELECT(TABLE(NAME=~"maindata~") COLUMN(NAME=~"maindata.用户编号~")COLUMN(NAME=~"maindata.用户名~")COLUMN(NAME=~"maindata.住址~")COLUMN(NAME=~"maindata.收费所~")COLUMN(NAME=~"maindata.抄表员姓名~")COLUMN(NAME=~"maindata.管理员姓名~")COLUMN(NAME=~"maindata.用水类别~")COLUMN(NAME=~"maindata.定量标准~")COLUMN(NAME=~"maindata.人·物数~")COLUMN(NAME=~"maindata.单价~")COLUMN(NAME=~"maindata.加压费~")COLUMN(NAME=~"maindata.水表管理费~")COLUMN(NAME=~"maindata.附加费~")COLUMN(NAME=~"maindata.备注~"))ORDER(NAME = ~"maindata.用户编号~" ASC = yes) " update="maindata" updatewhere=1 updatekeyinplace=no retrieve.asneeded=yes )
text(band=header alignment="2" text="用户编号" border="0" color="33554432" x="9" y="8" height="76" width="352" html.valueishtml="0" name=用户编号_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="12639424" )
text(band=header alignment="2" text="用户名" border="0" color="33554432" x="370" y="8" height="76" width="672" html.valueishtml="0" name=用户名_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="12639424" )
text(band=header alignment="2" text="住址" border="0" color="33554432" x="1051" y="8" height="76" width="672" html.valueishtml="0" name=住址_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="12639424" )
text(band=header alignment="2" text="收费所" border="0" color="33554432" x="1733" y="8" height="76" width="261" html.valueishtml="0" name=收费所_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="12639424" )
text(band=header alignment="2" text="抄表员姓名" border="0" color="33554432" x="2002" y="8" height="76" width="393" html.valueishtml="0" name=抄表员姓名_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="12639424" )
text(band=header alignment="2" text="管理员姓名" border="0" color="33554432" x="2405" y="8" height="76" width="430" html.valueishtml="0" name=管理员姓名_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="12639424" )
text(band=header alignment="2" text="用水类别" border="0" color="33554432" x="2843" y="8" height="76" width="384" html.valueishtml="0" name=用水类别_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="12639424" )
text(band=header alignment="2" text="定量标准" border="0" color="33554432" x="3237" y="8" height="76" width="384" html.valueishtml="0" name=定量标准_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="12639424" )
text(band=header alignment="2" text="人·物数" border="0" color="33554432" x="3630" y="8" height="76" width="384" html.valueishtml="0" name=人·物数_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="12639424" )
text(band=header alignment="2" text="单价" border="0" color="33554432" x="4023" y="8" height="76" width="384" html.valueishtml="0" name=单价_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="12639424" )
text(band=header alignment="2" text="加压费" border="0" color="33554432" x="4416" y="8" height="76" width="384" html.valueishtml="0" name=加压费_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="12639424" )
text(band=header alignment="2" text="水表管理费" border="0" color="33554432" x="4809" y="8" height="76" width="384" html.valueishtml="0" name=水表管理费_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="12639424" )
text(band=header alignment="2" text="附加费" border="0" color="33554432" x="5202" y="8" height="76" width="384" html.valueishtml="0" name=附加费_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="12639424" )
text(band=header alignment="2" text="备注" border="0" color="33554432" x="5595" y="8" height="76" width="1161" html.valueishtml="0" name=备注_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="12639424" )
column(band=detail id=1 alignment="0" tabsequence=10 border="0" color="32768" x="9" y="16" height="56" width="352" format="[general]" html.valueishtml="0" name=用户编号 visible="1" edit.limit=10 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=2 alignment="0" tabsequence=20 border="0" color="33554432" x="370" y="16" height="56" width="672"
#5
format="[general]" html.valueishtml="0" name=用户名 visible="1" edit.limit=20 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=3 alignment="0" tabsequence=30 border="0" color="33554432" x="1051" y="16" height="56" width="672" format="[general]" html.valueishtml="0" name=住址 visible="1" edit.limit=20 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=4 alignment="0" tabsequence=40 border="0" color="33554432" x="1733" y="16" height="56" width="261" format="[general]" html.valueishtml="0" name=收费所 visible="1" edit.limit=2 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=5 alignment="0" tabsequence=50 border="0" color="33554432" x="2002" y="16" height="56" width="393" format="[general]" html.valueishtml="0" name=抄表员姓名 visible="1" edit.limit=8 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=6 alignment="0" tabsequence=60 border="0" color="33554432" x="2405" y="16" height="56" width="430" format="[general]" html.valueishtml="0" name=管理员姓名 visible="1" edit.limit=8 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=7 alignment="0" tabsequence=70 border="0" color="33554432" x="2843" y="16" height="56" width="384" format="[general]" html.valueishtml="0" name=用水类别 visible="1" edit.limit=3 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=8 alignment="1" tabsequence=80 border="0" color="33554432" x="3237" y="16" height="56" width="384" format="[general]" html.valueishtml="0" name=定量标准 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=9 alignment="1" tabsequence=90 border="0" color="33554432" x="3630" y="16" height="56" width="384" format="[general]" html.valueishtml="0" name=人·物数 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=10 alignment="1" tabsequence=100 border="0" color="33554432" x="4023" y="16" height="56" width="384" format="[general]" html.valueishtml="0" name=单价 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=11 alignment="1" tabsequence=110 border="0" color="33554432" x="4416" y="16" height="56" width="384" format="[general]" html.valueishtml="0" name=加压费 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=12 alignment="1" tabsequence=120 border="0" color="33554432" x="4809" y="16" height="56" width="384" format="[general]" html.valueishtml="0" name=水表管理费 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=13 alignment="1" tabsequence=130 border="0" color="33554432" x="5202" y="16" height="56" width="384" format="[general]" html.valueishtml="0" name=附加费 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=14 alignment="0" tabsequence=140 border="0" color="33554432" x="5595" y="16" height="56" width="1161" format="[general]" html.valueishtml="0" name=备注 visible="1" edit.limit=32000 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
htmltable(border="1" )
htmlgen(clientevents="1" clientvalidation="1" clientcomputedfields="1" clientformatting="0" clientscriptable="0" generatejavascript="1" netscapelayers="0" )
column(band=detail id=3 alignment="0" tabsequence=30 border="0" color="33554432" x="1051" y="16" height="56" width="672" format="[general]" html.valueishtml="0" name=住址 visible="1" edit.limit=20 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=4 alignment="0" tabsequence=40 border="0" color="33554432" x="1733" y="16" height="56" width="261" format="[general]" html.valueishtml="0" name=收费所 visible="1" edit.limit=2 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=5 alignment="0" tabsequence=50 border="0" color="33554432" x="2002" y="16" height="56" width="393" format="[general]" html.valueishtml="0" name=抄表员姓名 visible="1" edit.limit=8 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=6 alignment="0" tabsequence=60 border="0" color="33554432" x="2405" y="16" height="56" width="430" format="[general]" html.valueishtml="0" name=管理员姓名 visible="1" edit.limit=8 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=7 alignment="0" tabsequence=70 border="0" color="33554432" x="2843" y="16" height="56" width="384" format="[general]" html.valueishtml="0" name=用水类别 visible="1" edit.limit=3 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=8 alignment="1" tabsequence=80 border="0" color="33554432" x="3237" y="16" height="56" width="384" format="[general]" html.valueishtml="0" name=定量标准 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=9 alignment="1" tabsequence=90 border="0" color="33554432" x="3630" y="16" height="56" width="384" format="[general]" html.valueishtml="0" name=人·物数 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=10 alignment="1" tabsequence=100 border="0" color="33554432" x="4023" y="16" height="56" width="384" format="[general]" html.valueishtml="0" name=单价 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=11 alignment="1" tabsequence=110 border="0" color="33554432" x="4416" y="16" height="56" width="384" format="[general]" html.valueishtml="0" name=加压费 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=12 alignment="1" tabsequence=120 border="0" color="33554432" x="4809" y="16" height="56" width="384" format="[general]" html.valueishtml="0" name=水表管理费 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=13 alignment="1" tabsequence=130 border="0" color="33554432" x="5202" y="16" height="56" width="384" format="[general]" html.valueishtml="0" name=附加费 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=14 alignment="0" tabsequence=140 border="0" color="33554432" x="5595" y="16" height="56" width="1161" format="[general]" html.valueishtml="0" name=备注 visible="1" edit.limit=32000 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
htmltable(border="1" )
htmlgen(clientevents="1" clientvalidation="1" clientcomputedfields="1" clientformatting="0" clientscriptable="0" generatejavascript="1" netscapelayers="0" )
#6
to:： zhanwei(@_@,晕眩ING)
我试了，，，，好像没什么变化呀？？？还是使用retrieve as needed 了。
你都改哪儿了？？
对了，，this.post event ue_postopen()是什么意思？？？
我试了，，，，好像没什么变化呀？？？还是使用retrieve as needed 了。
你都改哪儿了？？
对了，，this.post event ue_postopen()是什么意思？？？
#7
1、retrieve as needed
2、先打开窗口，后检索数据
this.post event ue_postopen() 就是在窗口打开后再检索数据。
我把RETRIEVE()放在 UE_POSTOPEN()自定义事件中了
2、先打开窗口，后检索数据
this.post event ue_postopen() 就是在窗口打开后再检索数据。
我把RETRIEVE()放在 UE_POSTOPEN()自定义事件中了
#8
谢谢 ，，，我再试试。
#9
你的检索有条件吗，如果有，请将检索条件用到的列建上索引，如果没有将主键建成聚簇索引
#1
retrieve as needed 选中即可
#2
谢谢，，，，可是我要用于统计的话，该怎么办呢？
#3
To:morningdew(晓峰)
你跑哪去了？重装了ASA，刚看完，把下面的导进去看一看：
$PBExportHeader$w_id.srw
$PBExportComments$用户增、删、改窗口
forward
global type w_id from window
end type
type dw_id from datawindow within w_id
end type
end forward
global type w_id from window
integer width = 3497
integer height = 1876
boolean titlebar = true
string title = "用户增、删、改"
boolean controlmenu = true
boolean minbox = true
boolean maxbox = true
boolean resizable = true
long backcolor = 15793151
string icon = "AppIcon!"
event ue_postopen ( )
dw_id dw_id
end type
global w_id w_id
event ue_postopen();//检索数据
dw_id.retrieve()
end event
on w_id.create
this.dw_id=create dw_id
this.Control[]={this.dw_id}
end on
on w_id.destroy
destroy(this.dw_id)
end on
event open;dw_id.settransobject(sqlca)
this.post event ue_postopen()
end event
type dw_id from datawindow within w_id
integer x = 96
integer y = 96
integer width = 3305
integer height = 1416
integer taborder = 10
string title = "none"
string dataobject = "d_id"
boolean hscrollbar = true
boolean vscrollbar = true
boolean livescroll = true
borderstyle borderstyle = stylelowered!
end type
你跑哪去了？重装了ASA，刚看完，把下面的导进去看一看：
$PBExportHeader$w_id.srw
$PBExportComments$用户增、删、改窗口
forward
global type w_id from window
end type
type dw_id from datawindow within w_id
end type
end forward
global type w_id from window
integer width = 3497
integer height = 1876
boolean titlebar = true
string title = "用户增、删、改"
boolean controlmenu = true
boolean minbox = true
boolean maxbox = true
boolean resizable = true
long backcolor = 15793151
string icon = "AppIcon!"
event ue_postopen ( )
dw_id dw_id
end type
global w_id w_id
event ue_postopen();//检索数据
dw_id.retrieve()
end event
on w_id.create
this.dw_id=create dw_id
this.Control[]={this.dw_id}
end on
on w_id.destroy
destroy(this.dw_id)
end on
event open;dw_id.settransobject(sqlca)
this.post event ue_postopen()
end event
type dw_id from datawindow within w_id
integer x = 96
integer y = 96
integer width = 3305
integer height = 1416
integer taborder = 10
string title = "none"
string dataobject = "d_id"
boolean hscrollbar = true
boolean vscrollbar = true
boolean livescroll = true
borderstyle borderstyle = stylelowered!
end type
#4
$PBExportHeader$d_id.srd
$PBExportComments$用户信息
release 8;
datawindow(units=0 timer_interval=0 color=1073741824 processing=1 HTMLDW=no 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.prompt=no print.buttons=no print.preview.buttons=no grid.lines=0 )
header(height=68 color="536870912" )
summary(height=0 color="536870912" )
footer(height=0 color="536870912" )
detail(height=84 color="536870912" )
table(column=(type=char(10) update=yes updatewhereclause=yes key=yes name=用户编号 dbname="maindata.用户编号" )
column=(type=char(20) update=yes updatewhereclause=yes name=用户名 dbname="maindata.用户名" )
column=(type=char(20) update=yes updatewhereclause=yes name=住址 dbname="maindata.住址" )
column=(type=char(2) update=yes updatewhereclause=yes name=收费所 dbname="maindata.收费所" )
column=(type=char(8) update=yes updatewhereclause=yes name=抄表员姓名 dbname="maindata.抄表员姓名" )
column=(type=char(8) update=yes updatewhereclause=yes name=管理员姓名 dbname="maindata.管理员姓名" )
column=(type=char(3) update=yes updatewhereclause=yes name=用水类别 dbname="maindata.用水类别" )
column=(type=decimal(2) update=yes updatewhereclause=yes name=定量标准 dbname="maindata.定量标准" )
column=(type=decimal(2) update=yes updatewhereclause=yes name=人·物数 dbname="maindata.人·物数" )
column=(type=decimal(2) update=yes updatewhereclause=yes name=单价 dbname="maindata.单价" )
column=(type=decimal(2) update=yes updatewhereclause=yes name=加压费 dbname="maindata.加压费" )
column=(type=decimal(2) update=yes updatewhereclause=yes name=水表管理费 dbname="maindata.水表管理费" )
column=(type=decimal(2) update=yes updatewhereclause=yes name=附加费 dbname="maindata.附加费" )
column=(type=char(32767) update=yes updatewhereclause=yes name=备注 dbname="maindata.备注" )
retrieve="PBSELECT(TABLE(NAME=~"maindata~") COLUMN(NAME=~"maindata.用户编号~")COLUMN(NAME=~"maindata.用户名~")COLUMN(NAME=~"maindata.住址~")COLUMN(NAME=~"maindata.收费所~")COLUMN(NAME=~"maindata.抄表员姓名~")COLUMN(NAME=~"maindata.管理员姓名~")COLUMN(NAME=~"maindata.用水类别~")COLUMN(NAME=~"maindata.定量标准~")COLUMN(NAME=~"maindata.人·物数~")COLUMN(NAME=~"maindata.单价~")COLUMN(NAME=~"maindata.加压费~")COLUMN(NAME=~"maindata.水表管理费~")COLUMN(NAME=~"maindata.附加费~")COLUMN(NAME=~"maindata.备注~"))ORDER(NAME = ~"maindata.用户编号~" ASC = yes) " update="maindata" updatewhere=1 updatekeyinplace=no retrieve.asneeded=yes )
text(band=header alignment="2" text="用户编号" border="0" color="33554432" x="9" y="8" height="76" width="352" html.valueishtml="0" name=用户编号_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="12639424" )
text(band=header alignment="2" text="用户名" border="0" color="33554432" x="370" y="8" height="76" width="672" html.valueishtml="0" name=用户名_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="12639424" )
text(band=header alignment="2" text="住址" border="0" color="33554432" x="1051" y="8" height="76" width="672" html.valueishtml="0" name=住址_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="12639424" )
text(band=header alignment="2" text="收费所" border="0" color="33554432" x="1733" y="8" height="76" width="261" html.valueishtml="0" name=收费所_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="12639424" )
text(band=header alignment="2" text="抄表员姓名" border="0" color="33554432" x="2002" y="8" height="76" width="393" html.valueishtml="0" name=抄表员姓名_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="12639424" )
text(band=header alignment="2" text="管理员姓名" border="0" color="33554432" x="2405" y="8" height="76" width="430" html.valueishtml="0" name=管理员姓名_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="12639424" )
text(band=header alignment="2" text="用水类别" border="0" color="33554432" x="2843" y="8" height="76" width="384" html.valueishtml="0" name=用水类别_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="12639424" )
text(band=header alignment="2" text="定量标准" border="0" color="33554432" x="3237" y="8" height="76" width="384" html.valueishtml="0" name=定量标准_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="12639424" )
text(band=header alignment="2" text="人·物数" border="0" color="33554432" x="3630" y="8" height="76" width="384" html.valueishtml="0" name=人·物数_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="12639424" )
text(band=header alignment="2" text="单价" border="0" color="33554432" x="4023" y="8" height="76" width="384" html.valueishtml="0" name=单价_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="12639424" )
text(band=header alignment="2" text="加压费" border="0" color="33554432" x="4416" y="8" height="76" width="384" html.valueishtml="0" name=加压费_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="12639424" )
text(band=header alignment="2" text="水表管理费" border="0" color="33554432" x="4809" y="8" height="76" width="384" html.valueishtml="0" name=水表管理费_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="12639424" )
text(band=header alignment="2" text="附加费" border="0" color="33554432" x="5202" y="8" height="76" width="384" html.valueishtml="0" name=附加费_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="12639424" )
text(band=header alignment="2" text="备注" border="0" color="33554432" x="5595" y="8" height="76" width="1161" html.valueishtml="0" name=备注_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="12639424" )
column(band=detail id=1 alignment="0" tabsequence=10 border="0" color="32768" x="9" y="16" height="56" width="352" format="[general]" html.valueishtml="0" name=用户编号 visible="1" edit.limit=10 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=2 alignment="0" tabsequence=20 border="0" color="33554432" x="370" y="16" height="56" width="672"
$PBExportComments$用户信息
release 8;
datawindow(units=0 timer_interval=0 color=1073741824 processing=1 HTMLDW=no 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.prompt=no print.buttons=no print.preview.buttons=no grid.lines=0 )
header(height=68 color="536870912" )
summary(height=0 color="536870912" )
footer(height=0 color="536870912" )
detail(height=84 color="536870912" )
table(column=(type=char(10) update=yes updatewhereclause=yes key=yes name=用户编号 dbname="maindata.用户编号" )
column=(type=char(20) update=yes updatewhereclause=yes name=用户名 dbname="maindata.用户名" )
column=(type=char(20) update=yes updatewhereclause=yes name=住址 dbname="maindata.住址" )
column=(type=char(2) update=yes updatewhereclause=yes name=收费所 dbname="maindata.收费所" )
column=(type=char(8) update=yes updatewhereclause=yes name=抄表员姓名 dbname="maindata.抄表员姓名" )
column=(type=char(8) update=yes updatewhereclause=yes name=管理员姓名 dbname="maindata.管理员姓名" )
column=(type=char(3) update=yes updatewhereclause=yes name=用水类别 dbname="maindata.用水类别" )
column=(type=decimal(2) update=yes updatewhereclause=yes name=定量标准 dbname="maindata.定量标准" )
column=(type=decimal(2) update=yes updatewhereclause=yes name=人·物数 dbname="maindata.人·物数" )
column=(type=decimal(2) update=yes updatewhereclause=yes name=单价 dbname="maindata.单价" )
column=(type=decimal(2) update=yes updatewhereclause=yes name=加压费 dbname="maindata.加压费" )
column=(type=decimal(2) update=yes updatewhereclause=yes name=水表管理费 dbname="maindata.水表管理费" )
column=(type=decimal(2) update=yes updatewhereclause=yes name=附加费 dbname="maindata.附加费" )
column=(type=char(32767) update=yes updatewhereclause=yes name=备注 dbname="maindata.备注" )
retrieve="PBSELECT(TABLE(NAME=~"maindata~") COLUMN(NAME=~"maindata.用户编号~")COLUMN(NAME=~"maindata.用户名~")COLUMN(NAME=~"maindata.住址~")COLUMN(NAME=~"maindata.收费所~")COLUMN(NAME=~"maindata.抄表员姓名~")COLUMN(NAME=~"maindata.管理员姓名~")COLUMN(NAME=~"maindata.用水类别~")COLUMN(NAME=~"maindata.定量标准~")COLUMN(NAME=~"maindata.人·物数~")COLUMN(NAME=~"maindata.单价~")COLUMN(NAME=~"maindata.加压费~")COLUMN(NAME=~"maindata.水表管理费~")COLUMN(NAME=~"maindata.附加费~")COLUMN(NAME=~"maindata.备注~"))ORDER(NAME = ~"maindata.用户编号~" ASC = yes) " update="maindata" updatewhere=1 updatekeyinplace=no retrieve.asneeded=yes )
text(band=header alignment="2" text="用户编号" border="0" color="33554432" x="9" y="8" height="76" width="352" html.valueishtml="0" name=用户编号_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="12639424" )
text(band=header alignment="2" text="用户名" border="0" color="33554432" x="370" y="8" height="76" width="672" html.valueishtml="0" name=用户名_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="12639424" )
text(band=header alignment="2" text="住址" border="0" color="33554432" x="1051" y="8" height="76" width="672" html.valueishtml="0" name=住址_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="12639424" )
text(band=header alignment="2" text="收费所" border="0" color="33554432" x="1733" y="8" height="76" width="261" html.valueishtml="0" name=收费所_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="12639424" )
text(band=header alignment="2" text="抄表员姓名" border="0" color="33554432" x="2002" y="8" height="76" width="393" html.valueishtml="0" name=抄表员姓名_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="12639424" )
text(band=header alignment="2" text="管理员姓名" border="0" color="33554432" x="2405" y="8" height="76" width="430" html.valueishtml="0" name=管理员姓名_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="12639424" )
text(band=header alignment="2" text="用水类别" border="0" color="33554432" x="2843" y="8" height="76" width="384" html.valueishtml="0" name=用水类别_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="12639424" )
text(band=header alignment="2" text="定量标准" border="0" color="33554432" x="3237" y="8" height="76" width="384" html.valueishtml="0" name=定量标准_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="12639424" )
text(band=header alignment="2" text="人·物数" border="0" color="33554432" x="3630" y="8" height="76" width="384" html.valueishtml="0" name=人·物数_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="12639424" )
text(band=header alignment="2" text="单价" border="0" color="33554432" x="4023" y="8" height="76" width="384" html.valueishtml="0" name=单价_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="12639424" )
text(band=header alignment="2" text="加压费" border="0" color="33554432" x="4416" y="8" height="76" width="384" html.valueishtml="0" name=加压费_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="12639424" )
text(band=header alignment="2" text="水表管理费" border="0" color="33554432" x="4809" y="8" height="76" width="384" html.valueishtml="0" name=水表管理费_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="12639424" )
text(band=header alignment="2" text="附加费" border="0" color="33554432" x="5202" y="8" height="76" width="384" html.valueishtml="0" name=附加费_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="12639424" )
text(band=header alignment="2" text="备注" border="0" color="33554432" x="5595" y="8" height="76" width="1161" html.valueishtml="0" name=备注_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="12639424" )
column(band=detail id=1 alignment="0" tabsequence=10 border="0" color="32768" x="9" y="16" height="56" width="352" format="[general]" html.valueishtml="0" name=用户编号 visible="1" edit.limit=10 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=2 alignment="0" tabsequence=20 border="0" color="33554432" x="370" y="16" height="56" width="672"
#5
format="[general]" html.valueishtml="0" name=用户名 visible="1" edit.limit=20 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=3 alignment="0" tabsequence=30 border="0" color="33554432" x="1051" y="16" height="56" width="672" format="[general]" html.valueishtml="0" name=住址 visible="1" edit.limit=20 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=4 alignment="0" tabsequence=40 border="0" color="33554432" x="1733" y="16" height="56" width="261" format="[general]" html.valueishtml="0" name=收费所 visible="1" edit.limit=2 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=5 alignment="0" tabsequence=50 border="0" color="33554432" x="2002" y="16" height="56" width="393" format="[general]" html.valueishtml="0" name=抄表员姓名 visible="1" edit.limit=8 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=6 alignment="0" tabsequence=60 border="0" color="33554432" x="2405" y="16" height="56" width="430" format="[general]" html.valueishtml="0" name=管理员姓名 visible="1" edit.limit=8 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=7 alignment="0" tabsequence=70 border="0" color="33554432" x="2843" y="16" height="56" width="384" format="[general]" html.valueishtml="0" name=用水类别 visible="1" edit.limit=3 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=8 alignment="1" tabsequence=80 border="0" color="33554432" x="3237" y="16" height="56" width="384" format="[general]" html.valueishtml="0" name=定量标准 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=9 alignment="1" tabsequence=90 border="0" color="33554432" x="3630" y="16" height="56" width="384" format="[general]" html.valueishtml="0" name=人·物数 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=10 alignment="1" tabsequence=100 border="0" color="33554432" x="4023" y="16" height="56" width="384" format="[general]" html.valueishtml="0" name=单价 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=11 alignment="1" tabsequence=110 border="0" color="33554432" x="4416" y="16" height="56" width="384" format="[general]" html.valueishtml="0" name=加压费 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=12 alignment="1" tabsequence=120 border="0" color="33554432" x="4809" y="16" height="56" width="384" format="[general]" html.valueishtml="0" name=水表管理费 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=13 alignment="1" tabsequence=130 border="0" color="33554432" x="5202" y="16" height="56" width="384" format="[general]" html.valueishtml="0" name=附加费 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=14 alignment="0" tabsequence=140 border="0" color="33554432" x="5595" y="16" height="56" width="1161" format="[general]" html.valueishtml="0" name=备注 visible="1" edit.limit=32000 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
htmltable(border="1" )
htmlgen(clientevents="1" clientvalidation="1" clientcomputedfields="1" clientformatting="0" clientscriptable="0" generatejavascript="1" netscapelayers="0" )
column(band=detail id=3 alignment="0" tabsequence=30 border="0" color="33554432" x="1051" y="16" height="56" width="672" format="[general]" html.valueishtml="0" name=住址 visible="1" edit.limit=20 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=4 alignment="0" tabsequence=40 border="0" color="33554432" x="1733" y="16" height="56" width="261" format="[general]" html.valueishtml="0" name=收费所 visible="1" edit.limit=2 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=5 alignment="0" tabsequence=50 border="0" color="33554432" x="2002" y="16" height="56" width="393" format="[general]" html.valueishtml="0" name=抄表员姓名 visible="1" edit.limit=8 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=6 alignment="0" tabsequence=60 border="0" color="33554432" x="2405" y="16" height="56" width="430" format="[general]" html.valueishtml="0" name=管理员姓名 visible="1" edit.limit=8 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=7 alignment="0" tabsequence=70 border="0" color="33554432" x="2843" y="16" height="56" width="384" format="[general]" html.valueishtml="0" name=用水类别 visible="1" edit.limit=3 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=8 alignment="1" tabsequence=80 border="0" color="33554432" x="3237" y="16" height="56" width="384" format="[general]" html.valueishtml="0" name=定量标准 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=9 alignment="1" tabsequence=90 border="0" color="33554432" x="3630" y="16" height="56" width="384" format="[general]" html.valueishtml="0" name=人·物数 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=10 alignment="1" tabsequence=100 border="0" color="33554432" x="4023" y="16" height="56" width="384" format="[general]" html.valueishtml="0" name=单价 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=11 alignment="1" tabsequence=110 border="0" color="33554432" x="4416" y="16" height="56" width="384" format="[general]" html.valueishtml="0" name=加压费 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=12 alignment="1" tabsequence=120 border="0" color="33554432" x="4809" y="16" height="56" width="384" format="[general]" html.valueishtml="0" name=水表管理费 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=13 alignment="1" tabsequence=130 border="0" color="33554432" x="5202" y="16" height="56" width="384" format="[general]" html.valueishtml="0" name=附加费 visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
column(band=detail id=14 alignment="0" tabsequence=140 border="0" color="33554432" x="5595" y="16" height="56" width="1161" format="[general]" html.valueishtml="0" name=备注 visible="1" edit.limit=32000 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
htmltable(border="1" )
htmlgen(clientevents="1" clientvalidation="1" clientcomputedfields="1" clientformatting="0" clientscriptable="0" generatejavascript="1" netscapelayers="0" )
#6
to:： zhanwei(@_@,晕眩ING)
我试了，，，，好像没什么变化呀？？？还是使用retrieve as needed 了。
你都改哪儿了？？
对了，，this.post event ue_postopen()是什么意思？？？
我试了，，，，好像没什么变化呀？？？还是使用retrieve as needed 了。
你都改哪儿了？？
对了，，this.post event ue_postopen()是什么意思？？？
#7
1、retrieve as needed
2、先打开窗口，后检索数据
this.post event ue_postopen() 就是在窗口打开后再检索数据。
我把RETRIEVE()放在 UE_POSTOPEN()自定义事件中了
2、先打开窗口，后检索数据
this.post event ue_postopen() 就是在窗口打开后再检索数据。
我把RETRIEVE()放在 UE_POSTOPEN()自定义事件中了
#8
谢谢 ，，，我再试试。
#9
你的检索有条件吗，如果有，请将检索条件用到的列建上索引，如果没有将主键建成聚簇索引