Options

not working in SELECT, working in FROM

austrianfoodispukeaustrianfoodispuke Posts: 100
edited June 2, 2008 7:29AM in SQL Prompt Previous Versions
My query is not showing columns when hitting "." in the SELECT part of the query

Other functionality works (caps, AS etc)

It is working fine in the FROM part.

Occurs in SQL2008 and SQL2005.

Have tried refreshing cache, reconnecting.

Query runs ok
· Share on Twitter

Comments

  • Options
    tanyatanya Posts: 269
    Hi,

    Are you trying to use alias or does it fail when you try to qualify the column names using table names?
    Can you give me an example of a query that causes this issue so that it helps me understand the issue?

    Many thanks,
    Tanya
    · Share on Twitter
  • Options
    austrianfoodispukeaustrianfoodispuke Posts: 100
    i can send the query that is causing the error (by email)

    you've already got the .snp of the db i'm using...
    · Share on Twitter
Sign In or Register to comment.