在client怎样实现更新？

Question

ClientData.ClientDataSet1.close;
  ClientData.ClientDataSet1.CommandText:='insert into test(name,age) values('joseph','20')';
  ClientData.ClientDataSet1.Execute;

Answer 1

ClientData.ClientDataSet1.Action:=False;
 错了吧，是.Active:=False;
不对，只要你在Server的TQuery关连的DataSetProvider的参数Options中Allowchangecommandtext选为True,
就可以在Client段中用：
begin
  ClientData.ClientDataSet1.close
  ClientData.ClientDataSet1.CommandText:='insert into test(name,age) values('+''''+'joseph,'+'20'+')';
  ClientData.ClientDataSet1.open;
end;