我用的是ADOQuery连接的数据库。
ADOQuery.Close;
ADOQuery.SQL.Clear;
ADOQuery.SQL.Text:='update Pass set PWD=trim(request.ContentFields.Values[''NewPwd''])';
ADOQuery.Open;
怎么有错?
该怎么样用?
ADOQuery.Close;
ADOQuery.SQL.Clear;
ADOQuery.SQL.Text:='update Pass set PWD=trim(request.ContentFields.Values[''NewPwd''])';
ADOQuery.Open;
怎么有错?
该怎么样用?
ADOQuery.SQL.Clear;
ADOQuery.SQL.Text:='update Pass set pwd='+''''+request.ContentFields.fieldbyname('newpwd').asstring+'''';
ADOQuery.execsql;
ADOQuery.SQL.Clear;
ADOQuery.SQL.Text:=Format('update Pass set PWD= %d ', [request.ContentFields.fieldbyname('newpwd').asstring]);
ADOQuery.ExecSql;
如果涉及改动数据库的用execsql
能返回结果的用open或active:=true
不管是ADOQuery.SQL.Text:='update Pass set pwd='+''''+request.ContentFields.fieldbyname('newpwd').asstring+'''';还是ADOQuery.SQL.Text:=Format('update Pass set PWD= %d ', [request.ContentFields.fieldbyname('newpwd').asstring]);
都有问题:(