Home » Developer & Programmer » Forms » forms (10G)
forms [message #355833] Mon, 27 October 2008 18:55 Go to next message
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 #355851 is a reply to message #355833] Tue, 28 October 2008 01:07 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'd think about using INSTEAD OF triggers.
Re: forms [message #356228 is a reply to message #355851] Thu, 30 October 2008 00:52 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Do NOT post in all upper case!!! Please post the definition of the view.

David
Previous Topic: LOV button
Next Topic: sample fmb report calling from form
Goto Forum:
  


Current Time: Sun Dec 11 04:29:45 CST 2016

Total time taken to generate the page: 0.11720 seconds