with DataM.PatTransferADOQ do
begin
close;
sql.Clear;
sql.Add('insert into adt_log values(:ward,:dept,:date_time,:Id,:visit,:action)');
parameters.ParamValues['ward']:=WardCode;
parameters.ParamValues['dept']:=deptCode;
parameters.ParamValues['Date_Time']:=OutDeptDateTimeP.DateTime;
parameters.ParamValues['id']:=id;
parameters.ParamValues['action']:='E';
DataM.PatTransferADOQ.ExecSQL;
在提交时报对象没有正确正义,请高手指点!!!
begin
close;
sql.Clear;
sql.Add('insert into adt_log values(:ward,:dept,:date_time,:Id,:visit,:action)');
parameters.ParamValues['ward']:=WardCode;
parameters.ParamValues['dept']:=deptCode;
parameters.ParamValues['Date_Time']:=OutDeptDateTimeP.DateTime;
parameters.ParamValues['id']:=id;
parameters.ParamValues['action']:='E';
DataM.PatTransferADOQ.ExecSQL;
在提交时报对象没有正确正义,请高手指点!!!
ftBoolean, ftFloat, ftCurrency, ftBCD, ftDate, ftTime, ftDateTime,
ftBytes, ftVarBytes, ftAutoInc, ftBlob, ftMemo, ftGraphic, ftFmtMemo,
ftParadoxOle, ftDBaseOle, ftTypedBinary, ftCursor, ftFixedChar, ftWideString,
ftLargeint, ftADT, ftArray, ftReference, ftDataSet, ftOraBlob, ftOraClob,
ftVariant, ftInterface, ftIDispatch, ftGuid, ftTimeStamp, ftFMTBcd);
Adoquery1.Parameters.ParamByName('x').DataType := ftString;
AdoQuery1.Parameters.Parambyname('x').Value = 'xxxxxxxxxxxx';
ADOQuery.Insert;
ADOQuery.FieldValues[]:='';
..
..
ADOQuery.post;就可以了
原来我少定义了一个变量,:visit