Problem with DragnDrop and SQL


im using the Dhtmlxgrid with a SQL database which works fine, however, I recently added the draganddrop function to my grid, which also works in theory, but when i relocate a Row using it, it doesnt update it to my Database.

For example, if I have 2 Rows, row 1 and row 2, and I switch them around using drag and drop, it does not update it in my Database, meaning that when I refresh the page, the two rows are not switched around like they should be.

Am i missing something?

Thanks in advance,


If you are using dataprocessor - it doesn’t update row indexes ( order of rows ) , only their data.

So it is impossible to use Drag and Drop with a SQL DB Dataprocessor? Since the order of things is the whole idea of a Drag and Drop… ? =/

DataProcessor can produce update calls on d-n-d actions, so it possible to catch info about such operation on server side, but there is no built in functionality which will save order of rows in client side grid. So while it not possible from-the-box, functionality can be added through custom coding.