各位大峡请帮忙看看,我这段代码错在什么地方啊? ADOQuery1.Close;
ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Text :='update compartmentuse set ydtime=abuttime where (cuid= '+quotedstr(fid)+')';ADOQuery1.ExecSql;其中ydtime是整形,abuttime是整形变量,当我执行的时候总提示update语句出错,请问怎么把一个变量付给一个字段啊????在线等待.请大家帮帮忙..
ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Text :='update compartmentuse set ydtime=abuttime where (cuid= '+quotedstr(fid)+')';ADOQuery1.ExecSql;其中ydtime是整形,abuttime是整形变量,当我执行的时候总提示update语句出错,请问怎么把一个变量付给一个字段啊????在线等待.请大家帮帮忙..
ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Text :='update compartmentuse set ydtime=:abuttime where (cuid= '+quotedstr(fid)+')';
ADOQuery1.Parameters.ParamByName('abuttime').Value := abuttime;ADOQuery1.ExecSql;
ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Text :=
format('update compartmentuse set ydtime = %d where cuid= ''%s'' ',[abuttime,fid ]);
ADOQuery1.ExecSql;
ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Text :='update compartmentuse set ydtime=:abuttime where cuid= '''+quotedstr(fid)+'''';