updating editable datatable from database failed

Hi,

Can you show the code you are using for the changing dataset variable?

After successfully received data from the server it's enough to update the body of your table, f.e:

        //Basic setup
        $('#dtBasicExample').DataTable();
        $('.dataTables_length').addClass('bs-select');
        //

       // saving your datatable to the variable
        let dataTable = $('#dtBasicExample');
        //saving datatable's body to the variable
        let dataTableBody = dataTable[0].childNodes[3];

        //After receiving data from the server 
        //you should process the data to the similar look 
        let updatedBody = `<tr>
          <td>Tiger Nixon</td>
          <td>System Architect</td>
          <td>Edinburgh</td>
          <td>61</td>
          <td>2011/04/25</td>
          <td>$320,800</td>
        </tr>
        <tr>
          <td>Garrett Winters</td>
          <td>Accountant</td>
          <td>Tokyo</td>
          <td>63</td>
          <td>2011/07/25</td>
          <td>$170,750</td>
        </tr>`;

         //sets the received and processed data as a body 
        const setNewBody = body => (dataTableBody.innerHTML = body);

        //
        fetch('...')
          .then(response => response.json())
          .then(() => setNewBody(updatedBody));

         //the code above should be replaced with:
         //then(data => processData(data))
         //then(res => setNewBody(res))

      });

Hope I could help.

Best regards.