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 2008 Forums
 Transact-SQL (2008)
 Invalid Column Name

Author  Topic 

ConfusedAgain
Yak Posting Veteran

82 Posts

Posted - 2011-05-03 : 10:23:27
What does this mean?

If I select query on a table one of the field names has a squiggle underneath, hover over that and it says 'Invalid column Name'

The field name is 'ConfType', how can that be an invalid name?

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2011-05-03 : 10:42:38
What tool do you use when you say that you can hover over something?


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

nigelrivett
Master Smack Fu Yak Hacker

3385 Posts

Posted - 2011-05-03 : 11:05:05
Could just be that the structure has been changed since you connected or maybe it's a temp table or you're in the context of the wrong database/user.
I guess this is management studio

ignore it unless you get an error whgen you try to run it.

==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

ConfusedAgain
Yak Posting Veteran

82 Posts

Posted - 2011-05-03 : 11:17:04
aye - it was in SSMS. I had added this as a new field (sorry should have mentioned that) when i logged out and logged back in the squiggly line had gone and no message appearing.

Go to Top of Page

Lamprey
Master Smack Fu Yak Hacker

4614 Posts

Posted - 2011-05-03 : 11:27:12
As an FYI, you can use SHIFT+CTRL+R to refresh the cache.
Go to Top of Page

ConfusedAgain
Yak Posting Veteran

82 Posts

Posted - 2011-05-03 : 11:42:04
Nice one I shall make a note of that.
Go to Top of Page
   

- Advertisement -