Hello

Can i use view for updateing row in table ?

Thanx
Michal

Yes you can. To be more precise: INSERT, UPDATE or DELETE statements executed
against views can result in changing contents of some tables. SELECT statement
on view (or table) can't.
IMHO the best way (and sometimes only way) to do it, is to write INSTEAD OF
trigger on the view.


Hilarion

vertigo wrote:
Only if it is a simple view. One you make direct mapping impossible,
for example with a group by or concatenation you must use instead-of
triggers.

--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)


-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------
http://www.newsfeed.com The #1 Newsgroup Service in the World!
-----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =-----