比如说,sql中有edit.text,有定义变量时,我总是没法写对,不知道如何加? username:=trim(edit1.Text);
datamodule1.adoq_pass_table.Close; datamodule1.adoq_pass_table.SQL.Clear; datamodule1.adoq_pass_table.SQL.Add('select * from pass_table');
datamodule1.adoq_pass_table.sql.add('where user_name= '+'"'+username+'"');
//编译说这句错,不知??
datamodule1.adoq_pass_table.open;
datamodule1.adoq_pass_table.first; label3.Caption:=datamodule1.adoq_pass_table.Fields[0].Value;
datamodule1.adoq_pass_table.Close; datamodule1.adoq_pass_table.SQL.Clear; datamodule1.adoq_pass_table.SQL.Add('select * from pass_table');
datamodule1.adoq_pass_table.sql.add('where user_name= '+'"'+username+'"');
//编译说这句错,不知??
datamodule1.adoq_pass_table.open;
datamodule1.adoq_pass_table.first; label3.Caption:=datamodule1.adoq_pass_table.Fields[0].Value;
'where user_name= '+'''+username+'''
只用单引号你如果觉得麻烦可用参数查找
parambyname('user_name').asstring :=username
try
open;
except
showmessage('error');
end;
datamodule1.adoq_pass_table.sql.add('where user_name= '''+username+'''');''''='
select * from table where a='aaa'
在query中:
query.sql.add('select * from table where a='+quotedstr(aaa));
正常sql语句:
select * from table where a=aaa
在query中:
query.sql.add('select * from table where a='+'aaa');
'WHERE USER_NAME='+ QuotedStr(username) + 'AND...'有什么不明白地就查帮助,有详细地说明