关于主从表维护的问题
if (FMainDataSource.DataSet is TADOQuery) and ((FMainDataSource.DataSet as TADOQuery).Connection <> nil) then
(FMainDataSource.DataSet as TADOQuery).Connection.BeginTrans;
if FMainDataSource.DataSet is TADOQuery then
(FMainDataSource.DataSet as TADOQuery).UpdateBatch(arAll);
//每次主表一提交后,从表里的存在缓存里的数据也被清空了,所以每次保存只能保存主表里的数据,不能保存从表更新后的数据。
if FChildDataSource.DataSet is TADOQuery then
(FChildDataSource.DataSet as TADOQuery).UpdateBatch(arall);
if (FMainDataSource.DataSet is TADOQuery) and ((FMainDataSource.DataSet as TADOQuery).Connection <> nil) then
(FMainDataSource.DataSet as TADOQuery).Connection.CommitTrans;
请问我应该怎么样改才能做到主从表同时保存?