你看这一句 clientdataset1.CommandText:='select jxbh,zgh,xm,jxmc,jxdw,jxnr,jxzfy,xxcd,grcd,jxcg,pzr,sfcg,jxgjmc,to_char(sjzi,'yyyy-MM-DD'),to_char(sjzhi,'YYYY-MM-DD') from jxb where '+sqlstr1+'';总是出错 1个missing operator or semicolon这个错误 2个incompatible types:string and integer 怎么解决?
clientdataset1.CommandText:='select jxbh,zgh,xm,jxmc,jxdw,jxnr,jxzfy,xxcd,grcd,jxcg,pzr,sfcg,jxgjmc,to_char(sjzi,''yyyy-MM-DD''),to_char(sjzhi,''YYYY-MM-DD'') from jxb where '+sqlstr1+'';
我比较菜这样是可以运行了。。只不过dbgrid里不能显示
clientdataset1.CommandText:='select jxbh,zgh,xm,jxmc,jxdw,jxnr,jxzfy,xxcd,grcd,jxcg,pzr,sfcg,jxgjmc,bz,to_char(sjzi,''yyyy-mm-dd'') sjzi1,to_char(sjzhi,''yyyy-mm-dd'') sjzhi1 from jxb where '+sqlstr1+''; 这样就可以了呵呵自己试出来了 谢谢啦。
clientdataset1.CommandText:='select jxbh,zgh,xm,jxmc,jxdw,jxnr,jxzfy,xxcd,grcd,jxcg,pzr,sfcg,jxgjmc,to_char(sjzi,'yyyy-MM-DD'),to_char(sjzhi,'YYYY-MM-DD') from jxb where '+sqlstr1+'';总是出错
1个missing operator or semicolon这个错误
2个incompatible types:string and integer
怎么解决?
否则我不需要去除掉时间
所以现在转用date型
这样就可以了呵呵自己试出来了
谢谢啦。