adoquery1.SQL.clear;
adoquery1.SQL.Add('select * from content where mfilename not like ''%.tif''');
adoquery1.SQL.Add('where mfilename like '+QuotedStr('%'+edit1.text+'%')+'');
哪个好心人帮看看,这句错哪了?说我语法错误(操作符丢失)
adoquery1.SQL.Add('select * from content where mfilename not like ''%.tif''');
adoquery1.SQL.Add('where mfilename like '+QuotedStr('%'+edit1.text+'%')+'');
哪个好心人帮看看,这句错哪了?说我语法错误(操作符丢失)
adoquery1.SQL.clear;
adoquery1.SQL.Add('select * from content where mfilename not like ''%.tif''');
adoquery1.SQL.Add('and mfilename like '+QuotedStr('%'+edit1.text+'%')+'');
这两句要分开使用,或者直接使用 adoquery1.SQL.Add('select * from content where mfilename not like ''%.tif' '' + ' and mfilename like '+QuotedStr('%'+edit1.text+'%'));
adoquery1.SQL.Add('where mfilename like '+QuotedStr('%'+edit1.text+'%')+''); 这两句执行后,合并成一条语句,'select * from content where mfilename not like ''%.tif'''+'where mfilename like '+QuotedStr('%'+edit1.text+'%')+''当然错了,第一句和第二句间没有空格呀,而且同一句出现两个where也不对呀改成
'select * from content where mfilename not like '+QuotedStr('%.tif')+' and mfilename like '+QuotedStr('%'+edit1.text+'%')
adoquery1.SQL.Add('select * from content where mfilename not like ''%.tif''');
adoquery1.SQL.Add(' and mfilename like '+QuotedStr('%'+edit1.text+'%')+'');
应该是你缺少空格的问题 还有两个Where