Updating views in mysql
An insertable view with a WHERE which is always false but no CHECK OPTION is a view that accepts data but does not show them.You can think of a view as a lens looking at one or more tables.To further elaborate - if I update the table then does the view get updated even if I don't run any query on the view?Every time you execute a query on the view, it will fetch the data currently in tables - included all committed transactions on it, but not those UPDATE or INSERT queries taht have still not been committed.My intended use of the VIEW was to limit access by persons using the LO Base front end to sensitive information on the main table.I had previously tried to limit access by using field permissions on the underlying table, but again LO Base lets me down as it cannot reference a table where one or more of the fields are restricted for that user.Unless you ask me I will not keep telling you the time. That is, you can use them in statements such as UPDATE, DELETE, or INSERT to update the contents of the underlying table.If you have created the view of certain table then there is automatic update in the data in the view as you change the data or insert new data in its respective table. For a view to be updatable, there must be a one-to-one relationship between the rows in the view and the rows in the underlying table.
UPDATE viewname SET fieldc = '55'WHERE fieldb = 4Does anyone know how to get LO Base to be able to update a VIEW by a form? Andrew Instead it is supposed that you have another table mapping all your unique fieldc values to fielddb values so you would edit one value in that table in order to assign another fieldb value to a fieldc values. See "Second normal form" in Libre Office should be used as a 100% frontend. I have spent a lot of time researching about VIEWs on mysql with LO Base but by the nature of the word "View" it is difficult to get meaningful search results.