I had a user that found a bug in my app that tried to update 2 tables through a view. The user didn’t notice that his changes kept piling up over the few hrs he was working. I was wondering if Recovery Mode would allow me to get his changes even though the description in appsheet article doesn’t specifically mention this as a way to get the changes from this kind of error.
Hi @Austin_Lambeth! We have two follow up questions for you:
- What was the error that was received?
- Did the changes made go through to the data on the data on the backend?
1.Unable to add/edit/delete row in table ‘AppSheetView’. → One or more SQL errors has been encountered: One or more SQL errors has been encountered:\nThe insert/update operation to your MySQL join view will modify more than one MySQL base table. Please ask your database administrator to troubleshoot this problem.\nOriginal error message from the database: Can not modify more than one base table through a join view ‘Appsheet.AppSheetView’
2. No