I have a strange problem. Using two updatable views (each contains single table only), simple 1:n relationship on integer key. Default functionality works fine (no event code). Master as well as detail data can be updated fine via generated pages.
Now when I start using a master-detail page after a detail row update I get the error: Update Failed. Switching on debug mode shows all sql statements except the update statement for the detail row ?! It just prompts the red Update Failure message.No idea what goes wrong. Would anybody have a clue what or how I can check?version used is last V2018
Check to see if tables involved have any triggers, particularly BEFORE INSERT.I’ve seen that happen when there’s an old trigger (like when importing a DB to work on) and some changes have been made in either phpmaker code, events, field names, etc.
No triggers in database for these. Note that single edit is fine. It’s the grid version that fails for some reason. I don’t understand why the problem doesn’t show up in debug mode (there’s no sql errors in there. But then again, the update sql does not show up in the debug info as well…