您所在位置：主题：请教sql语句问题
xiulin
[专家分：200] 发布于 2006-07-01 19:24:00
var
sqlstr: string;
begin
sqlstr:='select * from table123 where (((Mid((组选号码),1,1)) In ('1','5','6')) AND ((Mid((组选号码),2,1)) In ('1','5','6')) AND ((Mid((组选号码),3,1)) In ('1','5','6')))';
adoquery1.close;
adoquery1.sql.clear;
adoquery1.sql.add(sqlstr);
adoquery1.open;
end;
我用的是access,不知sqlstr为什么会出现错误，请指教，错误提示：missing operator or semicolon
sqlstr: string;
begin
sqlstr:='select * from table123 where (((Mid((组选号码),1,1)) In ('1','5','6')) AND ((Mid((组选号码),2,1)) In ('1','5','6')) AND ((Mid((组选号码),3,1)) In ('1','5','6')))';
adoquery1.close;
adoquery1.sql.clear;
adoquery1.sql.add(sqlstr);
adoquery1.open;
end;
我用的是access,不知sqlstr为什么会出现错误，请指教，错误提示：missing operator or semicolon
