Ticket AS2671
Visible to All Users

Add support for the nested datasets

created 19 years ago

Proposed Solution:
Hi Guys, great to hear from you.
ClientDatasets is EXTREMLY important for developers who rely on DataSnap. Like the name suggests, a nested dataset is a dataset within a dataset. By nesting one dataset inside another, you can reduce your overall storage needs, increase the efficiency of network communications, and simplify data operations.
In the article bellow, written by Carl Jensen for the BDN, we can see how datasets work. Right now the ExpressQuantum Grid works great on this kind of Master-Detail relationships, as long as you work with separate grids. The moment i decide to put two grids together in a Master Detail Relationship multi level single grid display, it just stops working.
That right now is a big cons for our development, we are trying to come up with workarounds like specifying the master-detail relationship on the client side, but that kills the purpose of a nested clientdataset.
http://bdn.borland.com/article/0,1410,29825,00.html
If more information is needed, feel free to ask. Thanks in advance.

Comments (2)
DevExpress Support Team 19 years ago

    How do you want it to be implemented? How it should look in your opinion?

      In response to the feedback requested on how nested clientdatasets should be implemented on ExpressQuantum Grid.
      It already works in separate grids. It just stops working if you set them up in a master-detail multilevel single grid display. See comments on solution/request section.

      Answers

      created 19 years ago

      The reason why grid does not work with nested datasets the way you expect it to work is the same as why grid does not work with master-detail datasets when master-detail relationship is set on the dataset level.
      Grid (datacontroller actually) loads ALL detail data for ALL master records at once and this becomes a problem with nested or master-detail datasets. But you can turn On the GridMode option for both master and detail datacontrollers and grid will show nested dataset as detail for the currently focused master record. If you want to stay with GridMode = False, then you will need to do some tricks shown in the attached project, but still only one master record can be expanded a the same time.
      Is such solution enough for your tasks?

        Disclaimer: The information provided on DevExpress.com and affiliated web properties (including the DevExpress Support Center) is provided "as is" without warranty of any kind. Developer Express Inc disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.

        Confidential Information: Developer Express Inc does not wish to receive, will not act to procure, nor will it solicit, confidential or proprietary materials and information from you through the DevExpress Support Center or its web properties. Any and all materials or information divulged during chats, email communications, online discussions, Support Center tickets, or made available to Developer Express Inc in any manner will be deemed NOT to be confidential by Developer Express Inc. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.