Recent content by Roy

I have a client dataset, through a provider to an oracle dataset. There are three variables/ parameters which set within the program to select the data. The sql on the ods is: select var.*,var.rowid from vleAction var where riskcat = :riskcat and riskdrv = :riskdrv and eventbatch = :eventbatch...

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.

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...