FetchDetail and ADODataSet for Master/Detail Code

From: WilliamGui (williamgui_at_e-erpchina.com)
Date: 09/27/04 

Date: Mon, 27 Sep 2004 21:52:03 +0800

I use TClientDataSet and TADODataSet access SQL 2k database.
This's test code: http://www.e-erpchina.com/test.zip

I use TClientDataSet to solve modify LEFT JOIN fields question,
because i don't know use ADO's UNIQUE TABLE attribute. then i use
TClientDataSet.

I found this way is very slowly on open dataset action.
I track sql statement, i found too many SELECT sql for detail table of per
master record .

Then I set Provider options, FetchDetail is True,
and call FetchDetail procedure to get detail data,

but this's not my think, it SELECT sql also.

Why?