Home » Developer & Programmer » Forms » How make a block of base view in form?(can't coding in trigger)
How make a block of base view in form?(can't coding in trigger) [message #329193] Tue, 24 June 2008 08:15 Go to next message
vitas_haiyi
Messages: 36
Registered: April 2007
Member
Hi dear all
I make a block that data source is view, if I want to update this , I know there are two ways. One is make a Instead Of View,another way is coding in ON-UPDATE of form.

But I today heard someone talk about the third way, only setup in property of block. but I didn't heard all they said, who can tell me the third way to update a block of base view, it don't need coding in ON-UPDATE or trigger of view.

Re: How make a block of base view in form?(can't coding in trigger) [message #329200 is a reply to message #329193] Tue, 24 June 2008 08:32 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Google for updateable view in Oracle

[Updated on: Tue, 24 June 2008 08:33]

Report message to a moderator

Re: How make a block of base view in form?(can't coding in trigger) [message #329479 is a reply to message #329193] Wed, 25 June 2008 09:29 Go to previous messageGo to next message
cjack
Messages: 22
Registered: June 2008
Junior Member
Hi,

1. Create view block and layout as the table.
2. Check the view columns updatabel/insertable/deletable from blow query
SELECT *
FROM all_updatable_columns
where table_name='Replace your view name'
3. via above click you will know which columns can be updated or not
If can, not need do any changes, if no, you set the relational item "Query Only" property as "Yes".
4. if also can't insert, please add the schema name of view before view in the block "Query data source name" propery, like this apps.your_view_name.

Good Luck

Jack
Re: How make a block of base view in form?(can't coding in trigger) [message #330290 is a reply to message #329479] Sat, 28 June 2008 20:46 Go to previous message
vitas_haiyi
Messages: 36
Registered: April 2007
Member
thank you.I already known it.
if the view don't have group,distinct,set the key-mode of block is updateable,and then set one primary key, then the view can update le.
Finished.
Previous Topic: Please help me its urgent
Next Topic: Form hangs
Goto Forum:
  


Current Time: Mon Dec 05 08:49:22 CST 2016

Total time taken to generate the page: 0.31871 seconds