Home » RDBMS Server » Server Administration » Inssert into View
Inssert into View [message #373280] Mon, 09 April 2001 15:25 Go to next message
aish74
Messages: 19
Registered: March 2001
Junior Member
Hi

Please help !!!1
Iam trying to insert into view from a table (View has same structure as table).
I am getting unique constraint voilation error.

Note: The view is empty and have the same structure as table.

Report message to a moderator

Re: Inssert into View [message #373281 is a reply to message #373280] Mon, 09 April 2001 16:36 Go to previous messageGo to next message
Madhav Kasojjala
Messages: 42
Registered: November 2000
Member
what is view definition? & Do you have any db trigger on table/view that auto inserts any sequence values into columns?

Report message to a moderator

Re: Inssert into View [message #373291 is a reply to message #373280] Tue, 10 April 2001 05:35 Go to previous message
Abhijeet Patil
Messages: 1
Registered: April 2001
Junior Member
If u create a view from base table which contains rows,then this view will not empty because all rows exists in base table are automaticlly comes into view, also if u insert a row into view the row is automatically insert into base table...
so u insert a row which is already present in that base table thats why ur view gives error.

Report message to a moderator

Previous Topic: update date by adding 3 more months
Next Topic: report heading
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jul 01 15:46:43 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.