Developer Forum

1. How can I filter a Master ClientDataSet from the Detail ClientDataset field values ?

2. ClientDataSet Master-Detail with Inner Join

Hi... how could i do a ClientDataSet Master-Detail with Inner Join?

Example...
SqlDataSet1 - Select CAD_COD,CAD_NAME from Customer
DataSetProvider1
ClientDataSet1
DataSource1

SqlDataSet2 - Select Raca_Cod, Cad_Cod, Raca_Name from Racas inner join
Racas_Cadastro on Racas.Raca_Cod=Racas_Cadastro.Raca_Cod
DataSetProvider2
ClientDataSet2 - MasterSource (DataSource1), MasterField Cad_Cod,
IndexFieldNames Cad_Cod


Should works fine? but when a open the clientdataset2, erros "Tokens unknow,
where"... if i monitor de SQL that he automatically created, i can see,
"SELECT RACA, RACA_COD,CAD_COD FROM RACAS_CRIADOR where CAD_COD = ?
INNER JOIN RACAS_CADASTRO ON (RACAS_CRIADOR.RACA_COD =
RACAS_CADASTRO.RACA_COD), it ignored the inner join and putted the where
BEFORE the inner join, making the error occours...

What i doing wrong? Somebody could help me?

[]
Cezar Wagenheimer

3. How to simulate 'DISTINCT' in ClientDataSet master-detail connections tree?

4. ClientDataSets in Master-Detail question

5. Challenge: Master-Detail ClientDataSets from Stored Procs...

6. Fetch data on ClientDataSet Master-Detail relation

7. Master-Detail ClientDataSet update sequence

8. IBX ClientDataSet (Detail Problems)

9. Master-> Detail-> Detail with datagrids

10. Master-detail: why doesn't detail DS automatically track row of master (i.e. :param not updated)?

11. Master-detail: I see all the detail records if I append a detail record

12. ClientDataset with dbExpress Master Detail: access violations (D7.1 + update)

13. ADO - ClientDataSet - Master/Detail

14. ClientDataset Lookup on Master/Detail causes Access Violation

15. Master / detail with ClientDataSet.