table is readonly 怎么改

Question

    
                          zdupdate:='update 配比 set '+diaoduquery4.fieldbyname('对应字段').AsString+'='''+diaoduquery4.FieldByName('材料名称').AsString+'''';
                          edit25.text:=zdupdate;
                          diaoduquery6.Close;
                          diaoduquery6.DatabaseName:='jbzdb';
                          diaoduquery6.SQL.Clear;
                          diaoduquery6.SQL.Add(zdupdate);
                          diaoduquery6.Open;

Answer 1

  
  zdupdate:='update 配比 set '+diaoduquery4.fieldbyname('对应字段').AsString+'='''+diaoduquery4.FieldByName('材料名称').AsString+'''';
  edit25.text:=zdupdate;
  diaoduquery6.SQL.Clear;
  diaoduquery6.SQL.Add(zdupdate);
  diaoduquery6.execsql;这样就可以了，如果是打开一个有数据的表用open,如果是执行SQL语句就用execsql.

Answer 2

diaoduquery6.Open;=>diaoduquery6.ExecSQL;

Answer 3

楼上正确，update需用execsql来处理，如果是Select则可以用Open