MySQL Forums
Forum List  »  Views

Re: Cannot update a View
Posted by: Devart Team
Date: August 19, 2011 12:28AM

Your view cannot be updated. Have a look at this article - Updatable and Insertable Views

Also, I'd suggest you to rewrite your query. Something like this -

SELECT t1.* FROM
  jos_community_fields_values_copy t1
JOIN (SELECT
        User_ID
      FROM
        jos_community_fields_values_copy
      WHERE
        field_id = '4'AND Value = 'UK'
        OR
        field_id = '5'AND Value = 'Active') t2
ON t1.User_ID = t2.User_ID;

Devart Company,
MySQL management tools
http://www.devart.com/dbforge/mysql/

Options: ReplyQuote


Subject
Views
Written By
Posted
4263
August 18, 2011 02:03PM
Re: Cannot update a View
1705
August 19, 2011 12:28AM
1912
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.