我的数据库中有一个表
表结构
ZAZHIMC char no 100
BIANMA char no 20
PINYIN varchar no 100
XINGMING char no 40
XINGBIE char no 2
CHUSHENGRQ datetime no 8
XUEKELEI char no 40
ZHUANYELEI char no 200
DANWEI varchar no 200
TONGXINDZ varchar no 200
YOUZHENGBM char no 6
DIANHUA varchar no 50
E_MAIL varchar no 150
RENYUANLEI char no 20
FENLEI char no 20
BEIZHU text no 16
PROVINCE varchar no 40
UID varchar no 20
UPassWord varchar no 20
ZhiWu varchar no 20
ZhiCheng varchar no 20
ZhaoPian image no 16
ZhaoPianLX char no 10
Fax varchar no 30
Ming char no 100
Xing char no 100
TongXinDZDZ varchar no 500
DanWeiXingZhi varchar no 40
DaoShi varchar no 500
XueSheng varchar no 500
YuYan varchar no 30
ZhaoShengXX text no 16
ShenGaoSD varchar no 20
ShenGaoTD varchar no 20
DingYueEmail char no 2
HTTP varchar no 200
Country varchar no 200
索引
IDX_XINGMING_CLUSTER clustered located on PRIMARY ZAZHIMC, RENYUANLEI
IDX_XINGMING_UNIQUE nonclustered, unique located on PRIMARY ZAZHIMC, RENYUANLEI, XINGMING
SQL语句:
select ZAZHIMC,BIANMA,PINYIN,XINGMING,XINGBIE,CHUSHENGRQ,XUEKELEI,ZHUANYELEI,DANWEI,TONGXINDZ,YOUZHENGBM,DIANHUA,E_MAIL,RENYUANLEI,FENLEI,BEIZHU,PROVINCE,UID,UPassWord,ZhiWu,ZhiCheng,Fax,Ming,Xing,TongXinDZDZ,DanWeiXingZhi,ShenGaoTD,ShenGaoSD,DaoShi,XueSheng,YuYan,ZhaoShengXX,DingYueEmail,HTTP,Country from RENYUANXX
where RENYUANLEI="作者"
order by DANWEI,XINGMING我在程序中用DBedit,DBmemo等数据库控见显示用query(requestlive=true)选出的记录集
并用DBNavigator1控制字段的操作,但是当我第一次打开窗体(query.Open),修改一个字段值,并用DBNavigator1来post的时侯很慢,post进去以后,再Post就很快了,请问这是怎么回事,我已经Delphi编程两年了还是不知怎么回事!请知道的人指点一下好吗?
表结构
ZAZHIMC char no 100
BIANMA char no 20
PINYIN varchar no 100
XINGMING char no 40
XINGBIE char no 2
CHUSHENGRQ datetime no 8
XUEKELEI char no 40
ZHUANYELEI char no 200
DANWEI varchar no 200
TONGXINDZ varchar no 200
YOUZHENGBM char no 6
DIANHUA varchar no 50
E_MAIL varchar no 150
RENYUANLEI char no 20
FENLEI char no 20
BEIZHU text no 16
PROVINCE varchar no 40
UID varchar no 20
UPassWord varchar no 20
ZhiWu varchar no 20
ZhiCheng varchar no 20
ZhaoPian image no 16
ZhaoPianLX char no 10
Fax varchar no 30
Ming char no 100
Xing char no 100
TongXinDZDZ varchar no 500
DanWeiXingZhi varchar no 40
DaoShi varchar no 500
XueSheng varchar no 500
YuYan varchar no 30
ZhaoShengXX text no 16
ShenGaoSD varchar no 20
ShenGaoTD varchar no 20
DingYueEmail char no 2
HTTP varchar no 200
Country varchar no 200
索引
IDX_XINGMING_CLUSTER clustered located on PRIMARY ZAZHIMC, RENYUANLEI
IDX_XINGMING_UNIQUE nonclustered, unique located on PRIMARY ZAZHIMC, RENYUANLEI, XINGMING
SQL语句:
select ZAZHIMC,BIANMA,PINYIN,XINGMING,XINGBIE,CHUSHENGRQ,XUEKELEI,ZHUANYELEI,DANWEI,TONGXINDZ,YOUZHENGBM,DIANHUA,E_MAIL,RENYUANLEI,FENLEI,BEIZHU,PROVINCE,UID,UPassWord,ZhiWu,ZhiCheng,Fax,Ming,Xing,TongXinDZDZ,DanWeiXingZhi,ShenGaoTD,ShenGaoSD,DaoShi,XueSheng,YuYan,ZhaoShengXX,DingYueEmail,HTTP,Country from RENYUANXX
where RENYUANLEI="作者"
order by DANWEI,XINGMING我在程序中用DBedit,DBmemo等数据库控见显示用query(requestlive=true)选出的记录集
并用DBNavigator1控制字段的操作,但是当我第一次打开窗体(query.Open),修改一个字段值,并用DBNavigator1来post的时侯很慢,post进去以后,再Post就很快了,请问这是怎么回事,我已经Delphi编程两年了还是不知怎么回事!请知道的人指点一下好吗?
解决方案 »
- 求助 获取快捷方式信息,返回乱码问题?pchar数组转string乱码?
- Adotable如何访问有密码的Access数据库
- 求查询过生日职工的SQL语句(ACCESS数据库),如:查04月01日至06月13日之间过生日员工
- excel操作﹐請問如何復制一個工作表?
- 急!!要以access作为delphi的后台如何做
- 求助100分,如何通过UDP协议进行大文件传输
- 有关子表关联问题,高分奉上。
- 请问怎样才能获得当前网络的传输速率?
- 怎么回事?请大家看看我的程序,怎么有错啊?
- how to do it?
- 怎样循环取得DBGrid中第一列单元格中的所有内容,今天2:30加分!!!
- InstallShield 问题?
还有就是最好用Update语句来更新数据
所以,我個人認為,這個是sql server本身的原因,和程序沒有直接關係.