procedure Tfrm_rkcx.SpeedButton1Click(Sender: TObject);
var ss:string;
begin
dbgrid1.DataSource:=DataSource2;
query1.SQL.Clear;
query1.SQL.Add('select * from Detail_rk where Rksj='''+datetostr(rcrqedit.Date)+'''');
query1.Open;
为何总是出现[Microsoft][ODBC Microsoft Access Driver]中标准表达式中数据类型不匹配的错误我使用的是Access2000
var ss:string;
begin
dbgrid1.DataSource:=DataSource2;
query1.SQL.Clear;
query1.SQL.Add('select * from Detail_rk where Rksj='''+datetostr(rcrqedit.Date)+'''');
query1.Open;
为何总是出现[Microsoft][ODBC Microsoft Access Driver]中标准表达式中数据类型不匹配的错误我使用的是Access2000
或者
query1.SQL.Add('select * from Detail_rk where Rksj=DataValue('''+datetostr(rcrqedit.Date)+''')');