MySQL Forums
Forum List  »  Views

Cannot update a View
Posted by: Ryan Taylor
Date: August 18, 2011 02:03PM

Hi there
I am trying to update a view called FINDUKACTIVE which is built from the following select statement:

SELECT * FROM jos_community_fields_values_copy
WHERE User_ID IN (
SELECT User_ID FROM jos_community_fields_values_copy
WHERE field_id='4' AND Value='UK'
) AND User_ID IN (
SELECT User_ID FROM jos_community_fields_values_copy
WHERE field_id='5' AND Value='Active'
)

The view displays perfectly fine. However, I am then trying to update the view as follows.

UPDATE FINDUKACTIVE
SET value='Inactive'
WHERE field_id='5'

However, I receive an error telling me that the target is not updatable. Any ideas why?

Thanks in advance

Options: ReplyQuote


Subject
Views
Written By
Posted
Cannot update a View
4267
August 18, 2011 02:03PM
1717
August 19, 2011 12:28AM
1913
November 06, 2011 01:15PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.