Philip,

u> why are views containing joins not updatable?

my 2 cents: because no-one got around to implement a mechanism to
update them; alternatives exist, after all.

u> using sub-selects in update statements seems awfully roundabout (and without indeces, not terribly fast) ... stored
u> procs seem excessive, and yes, i could just write a quick app to do this via cursors ... but (please don't flame me)
u> aren't updatable views containing joins considered at least somewhat necessary in a relational database? (within
u> limits, understandably.)

yes.

u> do you guys have any usual/preferred ways of dealing with this?

I have been using triggers to make views updatable for
quite some time. That's an exclusive IB/Fb feature, and quite a
terrific one.

u> are views with joins -going- to be updatable in some
u> future release? (i didn't see it in any of the open or closed bugs, or the open/closed feature requests when i checked
u> earlier ... maybe i missed it?)

Can't remember; if it's not there, then you can add it.

Ciao
--
Nando mailto:nandod@...