What are the challenges you face when working across database platforms? Take the survey
Options

learned alias not working

bogiemanbogieman Posts: 5
edited September 3, 2007 6:43AM in SQL Prompt Previous Versions
I just installed SQL Prompt. I am now trying to modify an existing sql view all the tables. I have the "Learn aliases when typing" and "Learn aliases when opening or pasting text" checked.

SQL Prompt will not recognize that aliases exist in the view. I have tried pulling the view directly from the database as well as a sql text file. I have even tried changing the alias and it will not pick up the table alias.

I have tried other views and they work. The only thing I can see is that the from table is a sub-select. One view has a sub-select in a join and all aliases will show in the candidate list. I have found other views where the from table is a sub-select and the aliases will not show in the candidate list.

Comments

  • Options
    Bart ReadBart Read Posts: 997 Silver 1
    Hi there,


    Any chance you could post up the script please so I can try to work out what the problem is?


    Thanks,
    Bart
    Bart Read
    Principal Consultant
    bartread.com Ltd
Sign In or Register to comment.