Hallo,
das ist die Variante über Parameter die einwandfrei funktioniert.
Im Handbuch ist eine weiter Methode "Range based M/D" beschrieben
die allerdings nicht funktioniert bzw. ich etwas übersehe.
Im Handbuch steht:
Range based M/D
To setup the range based M/D relationship, perform the following steps:
1. Drop TADQuery ( see page 468) (or any other AnyDAC dataset) on a form. Name it qOrders. Setup it - lets assign the
SQL ( see page 490):
SELECT * FROM {id Orders}
2. Drop TDataSource on a form. Name it dsOrders. Set it DataSet to qOrders.
3. Drop TADQuery ( see page 468) on a form. Name it qOrderDetails. Setup it - lets assign the
SQL ( see page 490):
SELECT * FROM {id Order Details}
Then set MasterFields ( see page 482) to ORDERID, IndexFieldNames ( see page 480) to ORDERID and MasterSource
( see page 482) to dsOrders. The base setup is finished.
So, how it works ? AnyDAC builds for qOrderDetails a list of pairs - qOrders and qOrderDetails fields, where fields in each
pair have the same position, master fields in MasterFields ( see page 482), detail fields in IndexFieldNames ( see page
480).
When the current qOrders record is changed, AnyDAC applies the range to qOrderDetails, where details fields are equal to
corresponding master fields. In our case qOrderDetails OrderID field is equal to qOrder OrderID field.
Naja, egal ich werde weitermachen mit Parameter. Dankeschön.