with query1 do begin
sql.clear;
sql.add('select * from myTable where Birth=:fBirth');
params[0].AsDatetime := DateTimePicker.DateTime;
Open;
end;
sql.clear;
sql.add('select * from myTable where Birth=:fBirth');
params[0].AsDatetime := DateTimePicker.DateTime;
Open;
end;
Sql.text:='select * from myTable where Birth=#'+
datetostr(DateTimePicker.Date)+'#'
fADODataSet.CommandText:='select * from V_Authors Where Birth=#'+DatetoStr(fBirth.Date)+'#';
但是还是不行啊。上面的直接写的方法也不行
'select * from V_Authors Where Birth='+''''+DateToStr(fBirth.Date)+''''成功,
但是有时间参数一定要这样写吗?
Format('select * from tablename where birth=''%s''', [DataPicker.Date)];
用Format比较方便