| Not able to update a view ... Help meeeeeee [message #77965] |
Wed, 26 December 2001 04:12  |
J.Vijaya raghavan
Messages: 1
Registered: December 2001
|
Junior Member |
|
|
Hi OraGurus,
I am using Forms6i and Oracle 8.1.7 DB.
I was trying to update a view which is a combination of two tables. Primary keys for the first table are date,srno and the second table's keys are date,srno,t_code. I created a view based on these fields date,srno,t_code & second table.t_val. When I was trying to update t_val I got "Unable to insert or Update records".
I searched the entire messages in this site and I tried all the suggestions given there. I tried with instead of triggers , changing the block settings in Forms etc .. I was not able to update that.
thank you,
raghavan
----------------------------------------------------------------------
|
|
|
|
| Re: Not able to update a view ... Help meeeeeee [message #77967 is a reply to message #77965] |
Wed, 26 December 2001 09:31  |
sokeh
Messages: 77
Registered: August 2000
|
Member |
|
|
It is my understanding that you cannot update a view with a join condition.
A view with one table can be updated but not one with a two or more table join.
When in doubt, press the shift + f1 keys for a specific reason why you are getting the error message = "Unable to insert or Update records".
----------------------------------------------------------------------
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
