Detail OracleDataSet of Detail OracleDataset

[Jens Fudickar]

I have a problem of using a OracleDataset as Detail of a Detail-OracleDataset.

The Detail-Detail-Dataset will only be refreshed when the Detail-Dataset is Changed.

Changing the Master-Dataset changes only the Detail-Dataset and not the Detail-Detail-Dataset.

Who can help???

------------------

 

[Helene]

A very easy way to implement a master-detail lookup is to use the AfterScroll and AfterOpen events.

In those events of the master you can set the variable of the detail and open it.

In this case I would try to first write a AfterRefreshRecord, AfterQuery, and AfterOpen event handler on the detail, just showing which of them is called when the detail is refreshed. If one of them is executed, then you can use that event to set the variables and reopen the detail-detail dataset. I don't know how this would work when saving changes to the database, however.

 

[Marco Kalter]

I have tried the master/detail/detail situation by creating a form with a master dataset (dept), a detail dataset with the managers in this department, and another detail dataset with the employees that are managed by a certain manager. It works just fine, scrolling through the departments displays the correct managers and employees. What version of Direct Oracle Access are you using?

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