I have a grid with columns from 2 tables using the $g->select_command..I’ve defined the $g->table = “table 1”. By default the edit screen tries to update table1 with all columns in the grid which will throw an error of course because the table 2 columns don’t exist in table 1 . How do I suppress a column on the grid ( which isn’t in table 1) from the default update in the edit screen? Is there an option I can set or do i need to use a custom function to replace the base functionality?
Thanks
It never fails, break down and ask the question and you find the answer!
$col[“editable”] = false;
One option is to disable the edit property as you mentioned.
Another option is to use on_update callback function and write your own update logic in it, skipping the default grid update. You may have multiple updates in that code and other functions like emailing etc.