some questions, commit and managing user rights

Hello, we are looking for a custom solution which could feet all our needs for a new application which handles a lot of information saved in some database (MySQL). I think DHTMLxgrid could be the right choice with some custom options.

I have some questions about the product:

  1. Would it be possible to show data in the grid, modify the data and press a button to save all the new changed data?

Its usually an option called “disable autocommit” in some programs. We need this option because our users need to calculate temporary data at the grid, and once they check its right, they could commit/save all the changes to the database. We don’t mind if we need to create a temporary grid where users could change the data without directly modifying the database.

  1. Is it possible to validate data modifications based in User Rights from the Database or based in User Rights from the Grid?

  2. Is it possible to Manage User Rights for the Grid, so that they get the same rights from Mysql?

We don’t mind if we need to acquire some additional modules to meet the all the necessary functionality.

Thanks.

  1. To save data in grid you may use DataProcessor extension on the client side. You can disable auto update mode with following code:

dp.setUpdateMode(“off”)

dp.sendData();

Please find more information about DataProcessor here
docs.dhtmlx.com/doku.php?id=dhtm … cessor:toc

  1. Is it possible to validate data modifications based in User Rights from the Database or based in User Rights from the Grid?
    You can use Validation extension of dhtmlxGrid or DataProcessor validation.
    Please find more information here docs.dhtmlx.com/doku.php?id=dhtm … validation
    docs.dhtmlx.com/doku.php?id=dhtm … validation
    Examples are available here dhtmlx.com/docs/products/dht … alidation/
    dhtmlx.com/docs/products/dht … ation.html

  2. dhtmlxGrid is a fully client side component. You can initialize it in different ways base on user right. Please find more information about grid initialization here
    docs.dhtmlx.com/doku.php?id=dhtm … ialization
    docs.dhtmlx.com/doku.php?id=dhtm … ta_loading

thank you Olga, really appretiated.