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?
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.
CASCADED is treated as default if neither keyword is given.
If a row is rejected because of the CHECK OPTION, an error similar to the following is produced: ) and WITH CHECK OPTION is similar to a BLACKHOLE table: no row is ever inserted and no row is ever returned.
Don't use it for data definition statements such as CREATE, ALTER, DROP.
You have the right software for your specific database engine at hand.
but of course, once you have got that data, it will not send it again.
There are triggers for that, but still your database client has to query the view data out.
Libre Office provides simple grid views and input forms to let you run data manipulation statements (UPDATE, DELETE, INSERT) for one record at a time given that your record set is editable at all.
With Libre Office you can run data definition statements and data manipulation statements by means of the command line tool menu: Tools Thanks Villeroy, You have confirmed my conclusion that it is impossible.
You can use this example as a guide for customizing update property settings on a view.