怎么把变量的值送到.sql里面
例如:
p1,p2:integer;
query:string;
query:='insert into table1 values(:p1,:p2);';
query1.sql.add(query);
怎么不对的了
例如:
p1,p2:integer;
query:string;
query:='insert into table1 values(:p1,:p2);';
query1.sql.add(query);
怎么不对的了
Query2.SQL.Add('VALUES (:Name, :Capital, :Population)');Query2.Params[0].AsString := 'Liechtenstein';
Query2.Params[1].AsString := 'Vaduz';
Query2.Params[2].AsInteger := 420000;
Query2.ExecSQL;以上代码来自Delphi帮助。你选中Query的Params属性,按F1就可以得到。
query:='insert into table1 values(:p1,:p2)';
query:string;
query:='insert into table1 values(:p1,:p2);';
query1.sql.add(query);
query1.Params.ParmaByName('p1').value := p1;
query1.Params.ParmaByName('p2').value := p2;
query1.ExecSQL;
Query1.SQL.Add('SELECT * FROM TableName');
Query1.SQL.Add(' WHERE Field1 = '+IntToStr(P1));
Query1.SQL.Add(' AND Field2 LIKE "'+ P1 + '"');
Query1.SQL.Open;
Query1.SQL.Add(' WHERE Field1 = '+IntToStr(P1));
Query1.SQL.Add(' AND Field2 ='''+ P1 + '''');
Query1.SQL.Open;