刚才我问了个关于ADODATASET中的commandtext的长度不能超过128,很多人回答分几行来实现,可是我实际调试怎么也通不过!
adodataset1.CommandText:='';
adodataset1.CommandText := 'select id,statusflag,cityfield, childfield,landname,buildingno,';
adodataset1.CommandText :=adodataset1.CommandText + 'houseno,housetype,area,fitment,precativeprince,direction,';
adodataset1.CommandText :=adodataset1.CommandText + ' handleman ,registerdate from datacenter';
adodataset1.CommandText :=adodataset1.CommandText + ' order by registerdate desc ' ;
adodataset1.Open;我想上面的代码应该就是很多人给出的正确答案,但是仍然报128长度错误,请有实际操作经验的人回答!
adodataset1.CommandText:='';
adodataset1.CommandText := 'select id,statusflag,cityfield, childfield,landname,buildingno,';
adodataset1.CommandText :=adodataset1.CommandText + 'houseno,housetype,area,fitment,precativeprince,direction,';
adodataset1.CommandText :=adodataset1.CommandText + ' handleman ,registerdate from datacenter';
adodataset1.CommandText :=adodataset1.CommandText + ' order by registerdate desc ' ;
adodataset1.Open;我想上面的代码应该就是很多人给出的正确答案,但是仍然报128长度错误,请有实际操作经验的人回答!
adodataset1.CommandText:= 'select id,statusflag,cityfield,‘
+’childfield,landname,buildingno,' + 'houseno,housetype,area,fitment,precativeprince,direction,'
+ ' handleman ,registerdate from datacenter'
+ ' order by registerdate desc ' ;
adodataset1.Open;