我目前設定如下:
Query1 - Provider1 - ClientDataSet1 - DataSource1, <--- Master
Query2 - Provider2 - ClientDataSet2 - DataSource2, <--- Detail
Master的SQL-Text, 對Query下指令
Provider2.Option.AllowCommandText:= true;
因此Master/Detail的連結關係為如下:
ClientDataSet2.MasterSource:= DataSource1;
ClientDataSet2.IndexFieldNames:= Detail_Key Fields
ClientDataSet2.CommandText:= 'SELECT * FROM DETAIL_TABLE WHERE Link_List_Of_Master_Detail';
一般操作和維謢使用都OK,
但問題來了,
我在Detail, 加一個TAggregateField, Expression:= 'SUM(QTY)';
當Master.AfterScroll,
TAggregateField的值就會一直累計,
不知有何辦法可以正確的使用TAggregateField ??

編輯記錄

經過幾天測試,
得到一個方案如下,

Query_M - Provider_M - ClientDataSet_M - DataSource_M, <--- Master
Query_D - Provider_D - ClientDataSet_D - DataSource_D, <--- Detail
Provider_M.Option.AllowCommandText:= false;
Provider_D.Option.AllowCommandText:= false;
Query_M.SQL.Text:= 'SELECT * FROM Master_Table';
Query_D.SQL.Text:= 'SELECT * FROM Detail_Table';
Query_D.MasterSource:= DataSource_M;
Query_D.MasterField:= LinkFields;
Query_D.IndexFieldNames:= DetailPKeyList;

Query_M.Open;
ClientDataSet_M.Open;
Query_D.Open;
ClientDataSet_D.Open;

ClientDataSet_M.AfterScroll也要
Query_D.Open;
ClientDataSet_D.Open;