Page 1 of 1

Update View

Posted: Sat Mar 25, 2023 2:38 am
by juniorpinto

when trying to update a form fed by a view. displays the following error:

An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1393 Can not modify more than one base table through a join view 'VW_NAME'

this view is formed by a left join of two tables and I can update it directly from the database. Does anyone know how to solve this problem?


Re: Update View

Posted: Sat Mar 25, 2023 8:52 am
by mobhar

You may search in this forum by using UpdateTable keyword for your references.