Hello,
when I have a grid and added a record, how can I fetch the inserted rows id and run 2 more queries (insert into another table). How can I do the same with an update?
Thank you
2 Answers
Your best bet is to use a custom update function which you define in the Grid Set-up, this is how I handle that scenario.
$e[“on_update”] = array(“update_data”,””,false);
Your update function would need to update the record and then add your additional SQL code at the end.
You can reference the Demo pages, “custom-events.php” for some ideas on how do handle this.
Thanks
Mike
Your Answer