procedure TForm1.Button2Click(Sender: TObject);
var today : string;
begin
today:=trim(DateToStr(now));
Query1.Active:=false;
Query1.Close;
Query1.SQL.Clear;
Query1.SQL.Add('select * from log where logdate=''+today+''');
{Query1.ExecSQL; }
Query1.Active:=TRUE;
end;
运行这段代码的结果是空,我觉得应该是today没有传进去,请各位大侠帮忙解决一下
var today : string;
begin
today:=trim(DateToStr(now));
Query1.Active:=false;
Query1.Close;
Query1.SQL.Clear;
Query1.SQL.Add('select * from log where logdate=''+today+''');
{Query1.ExecSQL; }
Query1.Active:=TRUE;
end;
运行这段代码的结果是空,我觉得应该是today没有传进去,请各位大侠帮忙解决一下
Query1.SQL.Add('select * from log where logdate='+'''+today+''');
Query1.SQL.Add('select * from log where logdate='+'''+today+''');这样写结果也是空啊
var
sqlstr string
...
begin
today:=trim(DateToStr(now));
Query1.Active:=false;
Query1.Close;
Query1.SQL.Clear;
sqlstr:=fromat('select * from log where logdate=''%s'',[]today);
Query1.SQL.Add(sqlstr);
query1.open;
end也可以使用showmessage(Query1.SQL.gettext)察看输入的sql语句
Query1.SQL.Add('select * from log where logdate='''+today+'''');