各位同仁,请教三层MTS问题.

[tom_yangzh]

通过ClientDataSet向数据交换服务器传送SQL语句时:
如果:
;
ClientDataSet1.close;
ClientDataSet1.CommandText:='select recorddate,shift,variety.varietyname,ration.rationname,speed,processtime,weight,cutdegree,stoptime,returnweight,operator,optime,remark 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个字符以内呀?
那如果我要实现把长命令串传送给数据交换服务器执行的话,又如何实现?

谢谢!

[Q287413288]

//把下面的字符串分成几行写就OK了
ClientDataSet1.close;
ClientDataSet1.CommandText:=
' select recorddate,shift,variety.varietyname,' +
' ration.rationname,speed,processtime,weight,' +
' cutdegree,stoptime,returnweight,operator,optime,' +
' remark from zjshiftcollect as zj,variety,ration where' +
' zj.variety=variety.varietyid and zj.ration=ration.rationid' +
' order by recorddate';
ClientDataSet1.open;

[zhangl_cn]

楼上的方法

[xthmpro_cn]

编辑器以行最多不能超过255个字符。