我有一个查询语句:
myRs.Open('select * from users where name=''+张三+'' ',myCn),这样可以.
但是,这样不行,报错:
myRs.Open('select * from users where name="'+cbo_user.Text+'" ',myCn)
另外我还试了如下几种形式,也不行,系统报错:
myRs.Open('select * from users where name='"+cbo_user.Text+"' ',myCn)
myRs.Open('select * from users where name=''+cbo_user.Text+'' ',myCn).请问:正确的写法是什么?谢谢诸位了!
myRs.Open('select * from users where name=''+张三+'' ',myCn),这样可以.
但是,这样不行,报错:
myRs.Open('select * from users where name="'+cbo_user.Text+'" ',myCn)
另外我还试了如下几种形式,也不行,系统报错:
myRs.Open('select * from users where name='"+cbo_user.Text+"' ',myCn)
myRs.Open('select * from users where name=''+cbo_user.Text+'' ',myCn).请问:正确的写法是什么?谢谢诸位了!
lsqltext:string;
begin
lsqltext:='select * from users where name='''+Edit1.text+'''';
Query.Text:=lsqltext;
Query.Open;
end;