OracleDataSet and ClientDataset - Variables

[jcmarcussojr]

Hi All !

I am doing some tests with OracleDataSet and ClientDataSet in my application.

The problem is that when I open the ClientDataSet all the variables of the OracleDataSet associated with the DataSetProvider are gone ! Then an exception is raised. Am I doing anything wrong ?
Other thing that I noticed: why does the method Close of the ClientDataSet calls the event OnBeforeGetRecords in the Provider associated with it ?
I am using Delphi 5.01 and DirectOracleAcess 3.4.6.1.

Thanks for reading. Hope you can help me !

Juliano
Brazil

 

[Marco Kalter]

Does this topic apply?

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

 

[ThomyKay]

Originally posted by mkalter:
Does this topic apply?

The variables in TOracleDataSet are deleted each time the CDS is opened and parameter values are NULL. In my opinion this is a TOracleDataSet bug in IProviderSupport interface implementation.

[This message has been edited by ThomyKay (edited 27 November 2002).]

 

[Marco Kalter]

The Variables of the TOracleDataSet are controlled by the Params of the TClientDataSet when it is opened. Each Param will result in a Variable, and any other Variable will be deleted.

Anyway, you are not the first to ask about this feature, and we'll add some ProviderOptions in the TOracleDataSet for the next release. Right now you must make sure that the Params are defined.

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

 

[Paulos]

Mark
----
If you use master details in ToracleDataset, providers and Client datasets and you change the master source ( ou even clean it and set again ), sometimes I got problems with the parameters list.

When fetching parameters you get an exception 'bound error'. The list is clear, and all variables are defined in Oracledataset.

Other times the parameter kind is changed, I don

 

[Marco Kalter]

I will check it out. If you have something to reproduce this problem, feel free to send it by e-mail. If this involves a lot of work, let me check it out first.

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

 

[nboodram]

I was having the same problem in the IDE this morning with the "not all variables bound" and then the "Index out of bounds (0)" errors. If I can create steps to easily reproduce, I will send them.

Natalie