Inssert into View [message #373280] |
Mon, 09 April 2001 15:25 |
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.
|
|
|
|
Re: Inssert into View [message #373291 is a reply to message #373280] |
Tue, 10 April 2001 05:35 |
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.
|
|
|