Hi folks
I'm testing DOA with a view to purchase and have come up against a problem which has already been raised in this forum - my problem is the suggested cures haven't worked.
I have a DatasetProvider feeding a ClientDataSet from an OracleDataSet. The OracleDataSet SQL has two parameters (a month and a year as 'To_Char..) and works fine.
My problem is that after running perfectly the first time the above error message appears when a second run with altered parameters is attempted.
The OracleDataSet is returning the correct number of rows but the ClientDataSet is retaining the original data, even after I refresh the dataset of the provider ('DataSetProvider1.DataSet.Refresh;')and 'FetchParams' and 'Execute' on the ClientDatSet.
This is new territory for me so if I'm making a really dumb newbie mistake could someone please put me on the right track and out of my misery?
BTW our Oracle version is 8.1.7.0 and I'm using D6 Enterprise.