SQLstr:='select * from temp where 测试日期='+char(39)+query1.fieldvalues['测试日期']+char(39);
SQLstr="select * from temp where 测试日期=' " & query1.fieldvalues['测试日期'] &"'
SQLstr:='select * from temp where 测试日期 = "'" + query1.fieldvalues['测试日期']+ "'"
这样 SQLstr:='select * from temp where 测试日期='+query1.fieldvalues['测试日期']+''; 不行的话SQLstr:='select * from temp where 测试日期="'+query1.fieldvalues['测试日期']+'"';
这样可是可以了,可以下又出现类似的错误SQLstr:='select * from '''+temp+'''where 编号='''+bh''' and 测试日期='''+query1.fieldvalues['测试日期']+'''';太谢谢各位了,很快揭帖谢谢
query1.fieldvalues['测试日期']两端不要引号看看
不好意思,写错了SQLstr:='select * from '''+temp+''' where 编号='''+bh+''' and 测试日期='''+query1.fieldvalues['测试日期']+'''';
"'"
SQLstr:='select * from temp where 测试日期='+query1.fieldvalues['测试日期']+'';
不行的话SQLstr:='select * from temp where 测试日期="'+query1.fieldvalues['测试日期']+'"';
是怎样去掉了,左右各去掉两个单引号'