查询D型数据的SQL的语句有什么不对的地方?
case 2:
{
DataModule1->HISTORYQuery1->SQL->Clear();
DataModule1->HISTORYQuery1->Close();
AnsiString queryString="SELECT * FROM HISTORY ";
queryString +=" WHERE LENDDATE= ";
queryString +="\"";
queryString +=StrToDate(DateToStr(FormatDateTime("yyyy-mm-dd", Now())));
queryString +="\"";
try
{
DataModule1->HISTORYQuery1->SQL->Add(queryString);
DataModule1->HISTORYQuery1->ExecSQL();
DataModule1->HISTORYQuery1->Active=true;
}
catch(EDBEngineError &E)
{
ShowMessage("不能查询此表");
return;
}
}
break;