cds + oracle dataset

[Roy]

I am a newbie to these components but cannot find a similar post (Note - there is a similar post from April 2003 but no replies) so ...

in delphi 7 I set up a client dataset with a dataset provider which is linked to an oracle dataset.

I open the oracle dataset and it's state is active.
I open the client dataset and the oracle dataset goes to dsInactive.
No statements between the two actions.

a) should this work?
b)h e l p !

Thanks

 

[Marco Kalter]

It can indeed be that the dataset is closed when the TDataSetProvider has fetched all records for the TClientDataSet.

 

[Roy]

OK so does this mean that I can ignore the state of the oracle dataset as it should be controlled by the client dataset requests? i.e. I do not need to set ods.active := true ?

Thanks

for information - I received an email reply stating that this is correct.

 

[Marco Kalter]

That is correct. The dataset will be opened/closed when necessary.