| modifying a view [message #126762] |
Wed, 06 July 2005 09:20  |
kavitharaman
Messages: 8
Registered: June 2005
|
Junior Member |
|
|
if a view is based on data retrieved from multiple tables can it be updated(not using any triggers)
RK
|
|
|
|
| Re: modifying a view [message #126780 is a reply to message #126762] |
Wed, 06 July 2005 11:16  |
Steve Callan
Messages: 44
Registered: January 2004
|
Member |
|
|
|
Do you mean can the view be updated, or can the underlying tables be updated? Your question as posted is very ambiguous. The answer is pretty much no for both scenarios. Further in Forms, what would cause something to be updated - initiated by the user? You will be hard pressed to do it withoug using a trigger.
|
|
|
|
| Re: modifying a view [message #126843 is a reply to message #126762] |
Wed, 06 July 2005 22:56 |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
If the view selects all the primary key fields, and there is a one-to-one relationship between these fields. That is, no duplicates in the view when accessed 'naturally', that is (again - sorry) there is no grouping, distinct, etc in the view definition.
To see if a column is updateable in a view look at SYS.USER_UPDATABLE_COLUMNS
Having ALL the primary keys, and a clear and direct linkage between records is the secret to updateable views.
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
