str ='select * from t1 a'+ 'left outer join t2 b on a.id=b.id'+ 'left outer join t3 c on a.id=c.id'+ 'where c.field like :v1' ; adoquery.sql.clear; adoquery.sql.add(str) ; adoquery.parameters.paramvalues['v1'] :='%查询条件%'; adoquery.open;
无法查到任何数据,如果直接赋值就可以:
str ='select * from t1 a'+ 'left outer join t2 b on a.id=b.id'+ 'left outer join t3 c on a.id=c.id'+ 'where c.field like ''%查询条件%''' ; adoquery.sql.clear; adoquery.sql.add(str) ; adoquery.open;