Using a ClientDataSet with an OracleDatset that joins 2 tables

[jcmarcussojr]

Hi!

I want to use a ClientDataSet linked to a Provider that's linked to OracleDataset that has a SELECT that joins 2 tables.

Doing this with IBX is easy because I can use a UpdateSQL to handle the UPDATE's (speccially). But with DOA, how can I do ?

My point is that some field of the second table (of the join) can be changed and the OracleDataset will try to change its value in the first table of the join. And by doing this will be raised an exception.

Thanks

Jose Carlos
Brazil

 

[Marco Kalter]

You will have to use the OnApplyRecord event (see PkgApply demo project for an example). You also need to set TDataSetProvider.ResolveToDataSet to True, otherwise this event will not be fired, because the TDataSetProvider will generate the SQL.

------------------
Marco Kalter
Allround Automations