Read Only cells in a simple View

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Read Only cells in a simple View

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2007-02-12 : 10:02:14

Mikel Arzak writes "Hi,

I have a DB migrated from SQL Server 2000 to SQL Server 2005 and I
have a strange problem that I don't find any reason.

I make a simple SQL Query with one table showing all the fields and
everything goes well. But when I insert another auxiliar table and
showing one field, then I can't change any field of the main table.
SQL Server shows me the message Read Only Cell. Why this happens? This problem didn't happen in SQL Server 2000.

The select sentence that works:

SELECT Notas_Estructura.* FROM Notas_Estructura

The previous Select sentence modified that doesn't work:

SELECT Notas_Estructura.*, Alumnos.Apellido1, Alumnos.Apellido2,
Alumnos.Nombre FROM Notas_Estructura INNER JOIN Alumnos ON Notas_Estructura.CodAlumno = Alumnos.CodAlumno

Thanks for your help."

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-02-12 : 10:09:09

Column names are supposed to be unique.
Make sure you haven't any columns named either Apellido1, Apellido2 nor Nombre in Notas_Estructura table.

Peter Larsson
Helsingborg, Sweden

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources