access数据库插入记录

Question

insert into CommInfo(flowID,beginDate,endDate) values (2,#2005-01-01 00:00:01#,#2005-10-01 10:20:01#)用adoQuery执行以上语句报错
“不正确的定义参数对象”，提供了不一致或不完整的信息" 怎么回事？

Answer 1

with dm.ADOQuery12 do begin
    Close;
    SQL.Clear;
    sql.Add('insert into CommInfo (flowID,beginDate,endDate) values(:temp1,:temp2,:temp3)');
    Parameters.ParamByName('temp1').Value:=2;
    Parameters.ParamByName('temp2').Value:=FormatDateTime('yyyy-mm-dd',DateTimePicker1.DateTime);
    Parameters.ParamByName('temp3').Value:=FormatDateTime('yyyy-mm-dd',DateTimePicker2.DateTime);
    ExecSQL;
    Close;
end;//end with
~~~~~~~~~~~~~~~~~~~~~~~~~~
参照...