| How make a block of base view in form?(can't coding in trigger) [message #329193] |
Tue, 24 June 2008 08:15  |
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 #329479 is a reply to message #329193] |
Wed, 25 June 2008 09:29  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
