Char ? 'select * from student where q_no=''99999'''
'select * from student where q_no='''99999''''
有两种方法: 1、ADOQuery.SQL.Add('select * from student where q_no=''99999'''); 2、adoquery.sql.add('select * from student where q_no=:a'); adoquery.paramery.paramerybyname('a').asstring:='999999'; 如果是整型,用ASINTEGER
'select * from student where q_no=''99999''' 或 'select * from student where q_no=99999'
'select * from student where q_no='''+Edit1.text+'''';呵呵
ADOQuery.SQL.Add('select * from student where q_no="99999"');
var S : String;begin S := 'select * from student where q_no='''99999''''//设断点跟一下;看看s的值。 ADOQuery.SQL.Add(S); end;
1、ADOQuery.SQL.Add('select * from student where q_no=''99999''');
2、adoquery.sql.add('select * from student where q_no=:a');
adoquery.paramery.paramerybyname('a').asstring:='999999';
如果是整型,用ASINTEGER
或 'select * from student where q_no=99999'
S : String;begin
S := 'select * from student where q_no='''99999''''//设断点跟一下;看看s的值。
ADOQuery.SQL.Add(S);
end;