commit matrix changes
Hi, I have to panes: Pane1, Pane2 with it a matrix each one.
When Pane1 is active I add rows to the matrix from pane2 (matrix2). But for the changes be made persisten to the database I need to change to the Pane2 and click the Update button. How can I commit these changes without having to click the Pane2 and clicking the update button?
I called the method FlushToDataSource from the matrix object with no results.
Owen Slater replied
Welcome to the forums.
We'll need to know some more information on what data you are trying to update before your question can be answered. Are you linking your form to a UDO, UDT or system data via the DBDataSource?
The FlushToDataSource method has no affect on the database, it just updates the values shown in the matrix on the client. If you are wanting to update a UDO then there is currently no way to directly update the UDO tables unless you click on the Update button on the form (or course, you could use the UI API to automatically click the button to force an update after you have changed values in the matrix). If you are wanting to update system data then you must use the relevant DI API object. If you are using data from a UDT, you can use the UserTables object to update the table (or send an update statement using the Recordset object, although this method is frowned upon by SAP).