![]() ![]() What we're trying to get at is that this "need" to edit data on a "regular" basis shouldn't exist, even in development. Here's to hoping that SQL 2008 allows edits with JOINs. You can still edit data in SSMS, so if they were trying to discourage poor behavior they should have removed editing data all together and forced people to write INSERT and UPDATE statements, preferably in transactions. Why? I don't know why they'd get rid of part of a feature. Trying the view in ASP.NET again, it works, yay!Ĭreate a SELECT query spanning a dozen tables showing the data that is causing an issue.Ĭopy the uniqueidentifier pk for the row.Ĭreate a new SELECT statement singling out that row. I notice one of the rows has errant data noticing that one of the cells is using an old enum value. So I create a SELECT query spanning a dozen tables showing the data that is causing an issue. Trying out a new list view in an ASP.NET page, but I'm getting a data casting exception in the code behind. When programming, I edit data for ad-hoc, one-time updates in a test environment for debugging purposes. I doubt we are alone here, the great thing about forums is that there is always some odd, esoteric reason something that is different is acceptable. Out of curiosity I also tried the same set of queries in SQL Express in Visual Studio 2005 and got the same results (darn.) That approach can get complicated really fast. Maybe I'm just going about it the wrong way □ But in the above example, usually I'll end up running my SELECT query with all the joins, then copy-pasting the PK for all the rows I want to edit into a new SELECT that only queries the single table that I am editing. This is rather annoying since it was possible in SQL 2000 Enterprise Manager. WHERE Player.LastName = 'Graham' AND Team.Name LIKE 'X%' PlayerTeam ON Player.Id = PlayerTeam.PlayerId INNER JOIN SELECT Player.FirstName, Player.LastName, Team.Name Even if I change the SQL to the following, I can still edit all the cells that are returned:īut once I toss in some joins everything grays out and the status bar says "Cell is Read Only.": Where in SSMS can you go to edit cells that are a result of multiple tables?įor example, if I open SSMS and right-click a table called Player then select Open Table I get:Īnd all the cells are editable. ![]()
0 Comments
Leave a Reply. |