我的程序:
adoconnection1.open;
adoquery1.Close;
adoquery1.SQL.Clear;
adoquery1.SQL.Add('update zbase_dianhuahaoma set dianhuahaoma =:phone, yonghu =:user, dizhi =:address where dianhuahaoma =:dianhuahaoma');
adoquery1.Parameters.ParamByName('phone').Value := trim(phone);
adoquery1.Parameters.ParamByName('user').Value := trim(user);
adoquery1.Parameters.ParamByName('address').Value := trim(address);
adoquery1.Parameters.ParamByName('dianhuahaoma').Value := trim(phone);
adoquery1.ExecSQL;
可为什么不能更新。没有报错。
adoconnection1.open;
adoquery1.Close;
adoquery1.SQL.Clear;
adoquery1.SQL.Add('update zbase_dianhuahaoma set dianhuahaoma =:phone, yonghu =:user, dizhi =:address where dianhuahaoma =:dianhuahaoma');
adoquery1.Parameters.ParamByName('phone').Value := trim(phone);
adoquery1.Parameters.ParamByName('user').Value := trim(user);
adoquery1.Parameters.ParamByName('address').Value := trim(address);
adoquery1.Parameters.ParamByName('dianhuahaoma').Value := trim(phone);
adoquery1.ExecSQL;
可为什么不能更新。没有报错。
adoquery1.CommitUpdates;报错,Adoquery没有这个方法吧。
adoquery1.SQL.Add('update zbase_dianhuahaoma set dianhuahaoma =:phone, yonghu =:user, dizhi =:address where dianhuahaoma =:dianhuahaoma; commit;');