注册 登录
编程论坛 Delphi论坛

请问为什么我到ExecSQL就出错,错在哪里求高手解答

Nattack 发布于 2011-06-11 22:59, 770 次点击
with DataModule1.ADOQuery2 do
      begin
        close;
        sql.Clear;
        sql.Add('select * from operator where user=:user');
        parameters.ParamByName('user').Value :=edit1.text;
        open;
        if (FieldValues['password']=edit1.Text) and (FieldValues['user']=username)  then
            begin
                if edit2.Text=edit3.Text then
                  begin
                    close;
                    sql.Clear;
                    sql.text:='update operator set password=:u '+'where password='''+edit1.text+'''';
                    parameters.ParamByName('u').Value :=edit2.text;
                    ExecSQL;
                    showmessage('密码修改成功');
                  end
                else
                  showmessage('新密码不相等');
              end
        else
          showmessage('原密码错误');
      end;
4 回复
#2
tw9202172011-06-13 16:19
看下错误信息是什么呢
#3
Nattack2011-06-15 17:38
说update语法错误
#4
司林林2011-06-16 15:55
数字技术与应用 CNKI收录QQ973530901
#5
chickenben2011-06-27 23:33
哈哈,应该是 where 前要加一个空格。
1