problem with updatable view an forms

From: Juergen Koehler <juergen.koehler4_at_de.bosch.com>
Date: Thu, 30 Jan 2003 10:51:43 +0100
Message-ID: <b1asjh$bdj$1@ns2.fe.internet.bosch.com>

Hi, everybody,

can anyone help me with the following problem?

I created an updatable view of 5 tables a,b,c,d,e. Therefor I had to join a with b, b with c and d, c with d and e. The system view "USER_UPDATABLE_COLUMNS" says that nearly every column is updatable (but not insertable or deletable).
If I do an update on this view via sqlplus it works. When I use a forms module with a block on this view the following message appears: "it is not possible to update the view". I set the block property "update changed columns only" to yes.
Does anybody knows what the problem is?

Greetings

Jürgen Köhler Received on Thu Jan 30 2003 - 03:51:43 CST