| forms [message #355833] |
Mon, 27 October 2008 18:55  |
riddhu
Messages: 1
Registered: October 2008
|
Junior Member |
|
|
I CREATED VIEW XYZV WTTH 3 TABLES....
TABLE X(SUB NUMBER,ROUND NUMBER,PASS VARCHAR2(10))
TABLE Y(ROUTE NUMBER,ROUND NUMBER)
TABLE Z(ELEMENT NUMBER,COST NUMBER,ROUTE NUMBER)
I HAVE CREATED FORM WITH THIS VIEW AND THE FORM CONTAINS THES COLUMNS
ELEMENT
COST
ROUTE
PASS
FIRST I QUERY ALL THE ROWS IN THE FORM AND I INSERT A ROW MAINLY I AM INSERTING ONLY IN THE Z TABLE
WHEN I INSERT I AM GETTING ORA-01776 CANNOT MODIFY MORE THAN ON BASE TABLE THROUGH join view.
how to solve this??please help
|
|
|
|
|
|
| Re: forms [message #356228 is a reply to message #355851] |
Thu, 30 October 2008 00:52  |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
Do NOT post in all upper case!!! Please post the definition of the view.
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
