Jump to content

Nested ClientDataSet-DataSetProvider problem. Call to Open poduces error "no current record" or some nested dataset data is missing.

Recommended Posts

Test case information

To reproduce the error specific data and specific, a bit complex, nested clientdataset layout is needed.

The test is just opening master clientdataset and walking through all its records including nested datasets. Result is written to memo box. To run it click on button Open ClientDataSet.

Button Run All Tests for Case ID runs repeated test for all option combinations . Output is saved in app's folder. Each dataset in its own .txt file. The name of the file includes chosen params.

For one set of data there is problem retreiving data from database into ClientDataSet component (Case 1 and Case 2). Either there is error on dataset open method and the other has one empty nested dataset where it should be one record present (cdsP40 dataset).

Calculated field is added on cdsP47 that is way down the nested hierarchy. This is the only calculated field in the project. It is created at run-time if settings Case Calculated Field Kind requires it. There is no OnCalculated event and calculated field isn't used anywhere. Just defined.


Case 1 - missing data record (empty cdsP40 dataset)

ID 7367

Fetch on demand

PacketRecord = 50

Case 2 - "no current record"

ID 7367


Fetch All

PacketRecord -1

Case 3 - all OK

ID 7367

No calculated fields / fkCalculated

Fetch All

PacketRecord -1

Case 4 - all OK

ID 7334


There is a demo application with small mssql database attached.


Share this post

Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now