var
str1,str2:string;
begin
str1:=trim(edit1.text);
str2:=copy(str1,0,2);
with adoquery1 do
begin
close;
sql.clear;
sql.add('select * from student');
sql.add('where address like 'str2%'');//在这行出现错误,请大家帮忙查找一下原因errer:')'expected but identifier "str2" found
prepared;
execsql;
end;
end;
str1,str2:string;
begin
str1:=trim(edit1.text);
str2:=copy(str1,0,2);
with adoquery1 do
begin
close;
sql.clear;
sql.add('select * from student');
sql.add('where address like 'str2%'');//在这行出现错误,请大家帮忙查找一下原因errer:')'expected but identifier "str2" found
prepared;
execsql;
end;
end;
sql.add('where address like ''str2%''');
引号的问题
我想以上的语句才是正确的.可以试一下
showmessage(adoquery1.sql.text);