JoinArray sample not removing the last access option

JoinArray sample not removing the last access option

fmeyer@nearbysoftware.comfmeyer@nearbysoftware.com Posts: 18Questions: 5Answers: 0

Hello Allan,

Using the one-to-many sample (https://editor.datatables.net/examples/advanced/joinArray.html) on my dev machine which is using SQL Server 2014 as the back end store I have weird issue: removing access options works well until I try to remove the last one which it does not.

Doing some debugging, on the client side it seems it sends the correct information, see the count to 0:

action:edit
data[row_28][users][first_name]:Basia
data[row_28][users][last_name]:Harrell
data[row_28][users][site]:2
data[row_28][access-many-count]:0

Unfortunately, the server still sends the same object with the last "Printer" access I tried to remove:

0: {DT_RowId: "row_28",…}
DT_RowId: "row_28"
access: [{id: "1", name: "Printer"}]
sites: {name: "London"}
users: {site: 2, first_name: "Basia", last_name: "Harrell", phone: "1-528-238-4178"}

On your site, the sample works well.
Does it have something to do with SQL Server?

Thanks
Frederic

This discussion has been closed.