What are the challenges you face when working across database platforms? Take the survey
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

Comments

  • Options
    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
  • Options
    i can send the query that is causing the error (by email)

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