updatable queries/views possible with any db?

[wahur]

I am looking for ANY experience with ANY database/driver combo which has been successfully used to produce updatable views/queries.

I cannot use native database because I need multiuser access.
From my personal experience you cannot do it with MySQL due to limitations in MySQL.
You cannot do it with PostgreSQL/SDBC due to driver being in early devel. I have not tried yet ODBC/JDBC drivers, if anyone knows please tell me.
It might be possible with SQLite but even database itself requires jumping through hoops to achieve this and I am not sure if driver allows it at all.
I have not looked into Firebird and Oracle yet.

What I want to do can also be done without this feature, but in a way that my father used to call 'repairing teeth through anus', I would really like to avoid it.

Wahur, getting desperate

[ze moo]

don't despair

MySQL 5+ can do views pretty well (only tested with the innodb storage engine though)

just make sure you don't use the "temptable" view-type which isn't updateable

cheers

/edit
example:

create or replace view your_db.your_view as select * from (your or another)_db.your_table where your_table.user = current_user;

creates an updateable view which only displays the rows the currently logged in user has access to (assumes your_table got a column "user")

[wahur]

Right. Problem is, this feature is still very much limited and even if you use merge the view still cannot include a join in order to be updateable. And thats what I want - to have a view that includes columns from multiple tables and that could be used to enter/edit info.
At least thats how I understood manual. Being newb in this area I might have misunderstood it. And next problem is, being such new feature in MySQL its not still supported by OOo so there is currently no way to create suitable OOo forms.

Wahur, thinkin about Qt Designer again