Question

delphi中select 的 where后面的id=变量怎么写

Answer 1

sqlstr:= 'select * from table where id=' + 变量;
dataset.SQL.text:= sqlstr;

Answer 2

Var
I: Integer;
Begin
I := 1000;
...
Mform1.ADOQuery2.SQL.Add(Format('SUM(wkptimere) - %d AS 生产能力 ', [I]));