onEditCellCommit help

I have a table component with its data bound to a named query. I’m trying to enable the user to edit the content of certain cells. The appropriate column has props.columns[#].editable set to true but I’m struggling with the onEditCellCommit event. Everything I scripted resulted in errors so I decided to use the example from the manual and build up from there. However, even the example script from the manual is giving me an error. And now I’m stumped.

This is the script…

This is the error (2 screenshots)…

What am I missing?

M Murphy

To start, change the return format of your query binding to ‘JSON’ from ‘Dataset’ - that should clear up the error you’re getting.

1 Like

Well, that did it! I feel silly now. Thanks for your help @PGriffith!

Perspective has other syntax as vision for editing cells?


image

Substantially different. Did you look at the code above?

Yes, but i get the same error.


I thought that the solution is to use SQL language
In that case i don’t understand what they refer to use JSON form Dataset…
I have the table in the SQL data base…

I’m returning a dataset from a message handler script and I can display that on a table with no problem but if I try to use the ‘OnCellEditCommit’ Action I’m getting the same error as @mmurphy. I tried converting the dataset to JSON string and a Dict using a script, and the table that I write is empty now (for both cases) since it’s expecting a dataset for props.data.

Is there a way to have a script in ‘onEditCellCommit’ in my case? I just want to know which cell was edited and the new value. TIA

Cheers
Sam