通过ClientDataSet向数据交换服务器传送SQL语句时:
如果:
;
ClientDataSet1.close;
ClientDataSet1.CommandText:='select recorddate,shift,variety.varietyname,ration.rationname,speed,processtime,weight,cutdegree,stoptime,returnweight,operator,optime,re from zjshiftcollect as zj,variety,ration where zj.variety=variety.varietyid and zj.ration=ration.rationid order by recorddate'
ClientDataSet1.open;
编译报错,说:string literals may have at most 255 elements是不是ClientDataSet的CommandText属性只能接受255个字符以内呀?
那如果我要实现把长命令串传送给数据交换服务器执行的话,又如何实现?谢谢!
如果:
;
ClientDataSet1.close;
ClientDataSet1.CommandText:='select recorddate,shift,variety.varietyname,ration.rationname,speed,processtime,weight,cutdegree,stoptime,returnweight,operator,optime,re from zjshiftcollect as zj,variety,ration where zj.variety=variety.varietyid and zj.ration=ration.rationid order by recorddate'
ClientDataSet1.open;
编译报错,说:string literals may have at most 255 elements是不是ClientDataSet的CommandText属性只能接受255个字符以内呀?
那如果我要实现把长命令串传送给数据交换服务器执行的话,又如何实现?谢谢!
解决方案 »
- 关于字符串的存取
- onkeydown事件不觸發了,怎么辦?
- 电子阅卷系统的问题
- 如何的控件动态生成控件名称是变量的控件?
- 我是CCNA,我想学Delphi,那本书比较好?
- 在Tquery.sql.add中是否可以使用集合性函数(sum,avg等),若不能用应怎么处理。不想用Tstoredproc
- 《UML with Rational Rose从入门到精通》
- 自Delphi7.0以来,大家凑一下,Delphi增加了哪些功能?
- 急 高手指教 如果通过doa连接远程的oralce数据库,且本地不用安装oralce客户端,行的通不
- 关于activeform 的问题!
- 谁有动态打印字段的例子?
- 跪求《DELPHI XML权威指南》一书
ClientDataSet1.close;
ClientDataSet1.CommandText:=
' select recorddate,shift,variety.varietyname,' +
' ration.rationname,speed,processtime,weight,' +
' cutdegree,stoptime,returnweight,operator,optime,' +
' re from zjshiftcollect as zj,variety,ration where' +
' zj.variety=variety.varietyid and zj.ration=ration.rationid' +
' order by recorddate';
ClientDataSet1.open;