Start Building Professional
Web Apps Today

CList manual update (override)

Grid #1 is using a CList cell which draws its list content from grid #2. Grid #2 is allowed to have a row deleted by a user. This creates a situation in which the Grid #1's CList cell may have an invalid reference to a list item now deleted by the user in Grid #2.

I can catch that use-case in code and update the CList in grid #1 manually. However, it appears the CList Excels is maintaining state, and on the first user click on the CList cell, the user will be presented a list that is old (reflects deleted item). Clicking on the cell again will draw the correct result.

My question, is there a ( private) property or method I can access and update the state of the CList from my own method?

I am manually updating the CList cell through a normal grid.cells(r,c).setValue(myNewList), which doesn't appear to be enough. The gird visually shows the correct CList values, but the first pop-up in the CList display includes the previously deleted value.

Thanks,
Dan

Unfortunately there is no way to change value of clis on fly. There is more easy way - use grid linked to grid. Please see example here http://192.168.1.94:81/test/pro/dhtmlxGrid/samples/interaction_other_components/pro_linked_grid.html

The link you posted is a private address.  

Sorry, here is correct link http://dhtmlx.com/docs/products/dhtmlxGrid/samples/interaction_other_components/pro_linked_grid.html

I had taken a look at that solution and ran into some errors. I am not clear if that was due to some errors on my part, so it would be helpful to clarify a couple of items.  The setSubGrid method needs to be executed before the parent Grid is initialized?  If yes, for my use-case, the subGrid and parentGrid will not contain any records at the time both sub and parent grids are intialized.  All rows will be manually entered by the user and the squence of when the user updates is each is random, so I need to keep the relationship state correct, which is what I was attempting with CList update.  Will the subgrid solution support this use-case?

Thanks,
Dan