learned alias not working
bogieman
Posts: 5
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.
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
Any chance you could post up the script please so I can try to work out what the problem is?
Thanks,
Bart
Principal Consultant
bartread.com Ltd