I´m trying to create a CRUD Hierarchical Kendo UI Grid to update both tables, but when I sent my data to server for create/update/delete, an error are generated: Unable to call SAVE-ROW-CHANGES(). Failed to create query for BEFORE-TABLE. (7211)
I saw the threads bellow, but I didn´t find how it´s work for create/update/delete.
William Pavei Antero
There are a couple of things to look at here.
To fix error (7211), we would need to see the payload being sent to the server to see the structure of the dataset. Then we would be able to figure out what is causing it.
Could you share the network info from the web inspector?
There are some few ways that you could handle changes from two Kendo UI Grids.
One approach uses settings for the transport: readLocal: true and autoSave: false.
These properties are not documented yet but they were mentioned on first threads that you listed above:
Are you using these properties?
How are you sending the changes to the server?
Are you sharing the same JSDO with both grids?
The general idea is that you would set readLocal: true and autoSave: false on the DataSource of the child grid.
In this way, the update would be saved into the shared JSDO and a sync() on the DataSource of the parent grid would send the changes to the server.
You would also need to handle the case where there are changes to the child grid but no changes to the patent grid.
What version of OpenEdge and the JSDO are you using?
I hope this helps.
When readLocal is set to TRUE, then the data is read from the JSDO via the JSDO memory
When readLocal is set to FALSE, then the data is read from the OpenEdge backend.
This sample uses the same JSDO instance for both parent and child datasources
Possess usage of readLocal and autoSave properties at JSDO datasource
Uses PDS template which is available as part of Telerik Platform
Possess JSDO 4.2
Thank you for your aswer.
I used the same example from http://oemobiledemo.progress.com/jsdo/example023.html.
Attached my source codes (backend and html), and the information from Chrome Inspector.
I´m using O.E. 11.6.3 and JSDO 4.2.0
Thank you for your help!
Now it´s work!
I just changed my Backend from CRUD to CRUD Submit.