DevForce Community Forum : Updatable View http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Updatable View Thu, 16 Jul 2026 12:40:33 -700 Fri, 28 Jan 2011 12:54:00 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=2471 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Updatable View : Hi Greg;It sounds like you're... http://www.ideablade.com/forum/forum_posts.asp?TID=2471&PID=9826#9826 Author: DenisK
Subject: 2471
Posted: 28-Jan-2011 at 12:54pm

Hi Greg;

It sounds like you're missing an alias somewhere in your SQL statement when building the view. You can read the following links to see the various ways you can miss an alias.

http://stackoverflow.com/questions/1888779/every-derived-table-must-have-its-own-alias

http://www.codeguru.com/forum/showthread.php?t=420682

http://bytes.com/topic/mysql/answers/877061-error-every-derived-table-must-have-its-own-alias

A Google search using the following keyword "Every derived table must have its own alias" also yields many results.

Hope this helps.
]]> Fri, 28 Jan 2011 12:54:00 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2471&PID=9826#9826 Updatable View : I am getting the following error... http://www.ideablade.com/forum/forum_posts.asp?TID=2471&PID=9823#9823 Author: gregweb
Subject: 2471
Posted: 28-Jan-2011 at 10:54am

I am getting the following error message when I try to udate an Entity.  The entity is created from a View, and the back end is MySql.  The view is a very simple view, based off one table.  It just has fewer fields than the base table, and it has a whereclause to limit the items (where IsDeleted = fasle).  The view is updatable per the MySql rules.
 
 
Entity Save Error: System.Data.UpdateException: An error occurred while updating the entries. See the inner exception for details. ---> MySql.Data.MySqlClient.MySqlException: Every derived table must have its own alias at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId) at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int32& insertedId) at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId) at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader() at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery() at MySql.Data.Entity.EFMySqlCommand.ExecuteNonQuery() at System.Data.Mapping.Update.Internal.DynamicUpdateCommand.Execute(UpdateTranslator translator, EntityConnection connection, Dictionary`2 identifierValues, List`1 generatedValues) at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter) --- End of inner exception stack trace --- at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter) at System.Data.EntityClient.EntityAdapter.Update(IEntityStateManager entityCache) at System.Data.Objects.ObjectContext.SaveChanges(SaveOptions options) at IdeaBlade.EntityModel.Edm.EdmSaveExecutor.ProcessSaves(IEnumerable`1 groupsByType) at IdeaBlade.EntityModel.Edm.EdmSaveExecutor.SaveWithinContext() at IdeaBlade.EntityModel.Edm.EdmSaveExecutor.Save(DataSourceResolver dataSourceResolver, IDataSourceKey dsKey, SaveWorkState workState)
 
Thanks,
 
Greg
]]> Fri, 28 Jan 2011 10:54:22 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2471&PID=9823#9823