The documentation says that a view is updateable under certain conditions. I am trying to set a lock in a view which is based on 2 column tables or 2 views. Unfortunately the create statement, for the ...
H2 does not have real updateable views. You can emulate them with triggers and this will work properly in regular update statements. But SELECT FOR UPDATE is a different story. It needs a row in a ...
Flg. SQL query virker fint i Transact SQL, men overfoert til Jet SQL (Access) giver den en fejl. Det er ikke et spoergsmaal om skriverettigheder, men jeg kan forstaa at man ikke kan bruge subselects ...