tryTADOQuery1.SQL.Add('Select * From Table1 Where ID='''+变量+''' ');
TADOQuery1.SQL.Add('Select * Form Table1 where id ='''+Edit1.Text+''''); 如果不是字符就 TADOQuery1.SQL.Add('Select * Form Table1 where id ='+Edit1.Text+'');
TADOQuery1.SQL.Add('Select * From Table1 Where ID=:ID'); TAOOQuery1.Parameters.ParamByName("ID").Value:=xxx;
TADOQuery1.SQL.Add('Select * Form Table1 where id ='+QuotedStr(Edit1.Text));参数 with adoquery1 do begin close; sql.clear; SQL.Add('Select * From Table1 Where ID=:Param_ID'); Parameters.ParamByName('Param_ID').Value:=edit1.text; open; end;
TADOQuery1.SQL.Add('Select * Form Table1 where id ='+QuotedStr(Edit1.Text));参数 with adoquery1 do begin close; sql.clear; SQL.Add('Select * From Table1 Where ID=:Param_ID'); Parameters.ParamByName('Param_ID').Value:=edit1.text; open; end;
呵呵 一种是直接用变量 一种是用参数TADOQuery1.SQL.Add('Select * Form Table1 where id ='''+Edit1.Text+'''');与TADOQuery1.SQL.Add('Select * From Table1 Where name=:myname'); TAOOQuery1.Parameters.ParamByName("myname").Value:=edit1.text;
TADOQuery1.SQL.Add('Select * From Table1 Where ID=:ID'); TAOOQuery1.Parameters.ParamByName("ID").Value:=xxx;
sql语句 TADOquery1.add('select * from "数据库名:表名"'); with adoquery1 do begin close; sql.clear;清空SQL SQL.ADD(SELECT * FROM 表名 where id=qaram_id); parameter.qarambyname=qaram_id.value:=edit1.text; end;
都答了,俺还答什么, 说一下吧:Format('Select * From Table1 Where ID=%s',[Edit1.text])
TADOquery1.add('select * from "数据库名:表名"'); with adoquery1 do begin close; sql.clear;清空SQL SQL.ADD(SELECT * FROM 表名 where id=qaram_id); parameter.qarambyname=qaram_id.value:=edit1.text; end;
注意字段类型,''相当于SQL语句的一个':如字符串需要加上'' TADOQuery1.SQL.Add('Select * Form Table1 where id ='''+Edit1.Text+'''');
TADOQuery1.SQL.Add('Select * Form Table1 where id ='''+Edit1.Text+'''');
TADOQuery1.SQL.Add('Select * From Table1 Where name=:myname'); TAOOQuery1.Parameters.ParamByName("myname").Value:=edit1.text;
这个问题好像不是很难哦。 with adoquery1 do begin close; sql.Clear; sql.Add('Select * From Table1 Where ID='''+edit1.text+''''); open; end; 如果是UPDATE、INSERT 的话应用adoquery1.ExecSQL
我的比较独特: with adoquery1 do begin close; sql.Clear; sql.Add('Select * From Table1 Where ID='+#39+edit1.text+'+#39+' '); open; end;
如果不是字符就
TADOQuery1.SQL.Add('Select * Form Table1 where id ='+Edit1.Text+'');
TAOOQuery1.Parameters.ParamByName("ID").Value:=xxx;
with adoquery1 do
begin
close;
sql.clear;
SQL.Add('Select * From Table1 Where ID=:Param_ID');
Parameters.ParamByName('Param_ID').Value:=edit1.text;
open;
end;
with adoquery1 do
begin
close;
sql.clear;
SQL.Add('Select * From Table1 Where ID=:Param_ID');
Parameters.ParamByName('Param_ID').Value:=edit1.text;
open;
end;
一种是直接用变量
一种是用参数TADOQuery1.SQL.Add('Select * Form Table1 where id ='''+Edit1.Text+'''');与TADOQuery1.SQL.Add('Select * From Table1 Where name=:myname');
TAOOQuery1.Parameters.ParamByName("myname").Value:=edit1.text;
呵呵!
一种是直接用变量
一种是用参数
还有一种是用函数,比如上边用到的quotedstr();
我喜欢用函数,理由1,不用在sql语句中+‘’,
理由2,不用指明在数据集中的变量
TAOOQuery1.Parameters.ParamByName("ID").Value:=xxx;
TADOquery1.add('select * from "数据库名:表名"');
with adoquery1 do
begin
close;
sql.clear;清空SQL
SQL.ADD(SELECT * FROM 表名 where id=qaram_id);
parameter.qarambyname=qaram_id.value:=edit1.text;
end;
说一下吧:Format('Select * From Table1 Where ID=%s',[Edit1.text])
with adoquery1 do
begin
close;
sql.clear;清空SQL
SQL.ADD(SELECT * FROM 表名 where id=qaram_id);
parameter.qarambyname=qaram_id.value:=edit1.text;
end;
TADOQuery1.SQL.Add('Select * Form Table1 where id ='''+Edit1.Text+'''');
TAOOQuery1.Parameters.ParamByName("myname").Value:=edit1.text;
with adoquery1 do
begin
close;
sql.Clear;
sql.Add('Select * From Table1 Where ID='''+edit1.text+'''');
open;
end;
如果是UPDATE、INSERT 的话应用adoquery1.ExecSQL
begin
close;
sql.Clear;
sql.Add('Select * From Table1 Where ID='+#39+edit1.text+'+#39+' ');
open;
end;