[FORMS] HOW MAKE UPDATE VIEW in FORMS?? [message #351111] |
Mon, 29 September 2008 05:42 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
|
I make a simple view
--------------------------------------
create or replace view as IS_CS01_V
Select .....
--------------------------------------
and make datablock -> IS_CS01_V
and datablock is displayed...
but i can`t insert text in recoard.
i set block property -> databse
insert allowed = yes,
update allowed = yes,
locking mode = immediate,
delete allowed = yes,
key mode = automatic...
and item property is same setting...
and item type : Text item.
but when i run form, i can`t insert item (in IS_CS01_V)
i want to only insert. no query!
but after query [Ctrl + F4], all items in BLOCK(IS_CS01_V) is changed display item.. so i can`t use update view..
what is the problem???
Help me !!
|
|
|
Re: [FORMS] HOW MAKE UPDATE VIEW in FORMS?? [message #351113 is a reply to message #351111] |
Mon, 29 September 2008 06:02 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
rajy_salim
Messages: 204 Registered: January 2008 Location: Beirut - Lebanon
|
Senior Member |
|
|
You cannot insert in a view since it's not a physical object. A view, as its name means, is to view data, you cannot neither insert nor update.
To insert the data you want, base your datablock on a table where you can use all the DML statements.
Rajy
|
|
|
|
|