Red Gate forums :: View topic - Qualify object names not working with temporary tables
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Prompt 6
SQL Prompt 6 forum

Qualify object names not working with temporary tables

Search in SQL Prompt 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
JDS44



Joined: 20 Sep 2013
Posts: 5

PostPosted: Tue Mar 25, 2014 10:29 pm    Post subject: Qualify object names not working with temporary tables Reply with quote

If the snippet below is run through SQL Prompt 6.2.0.366's Qualify Object Names process it highlights the two table names and the column name with unable to resolve errors.


Code:
CREATE TABLE #OverrideMonth (OverrideMonth INT)
       
SELECT OverrideMonth FROM #OverrideMonth om



Is this expected behavior?

If so is there any good way to see the list of items that have problems that I can maintain since I working on a 3000 line procedure that when I edit it to manually fix them all the underlined issues dissapear and I have to re-run and re-find the areas to hand fix.
Back to top
View user's profile Send private message
Aaron Law



Joined: 28 Jun 2013
Posts: 241
Location: Red Gate Software

PostPosted: Wed Mar 26, 2014 5:33 pm    Post subject: Reply with quote

Hi JDS44,

This looks like a bug to me, thanks for reporting it. I found a similar issue in our bug tracking system as SP-3198 which has been around for a while unfortunately. We have some work planned on revamping the qualify object names feature for the next version of SQL Prompt and I'll make sure that this gets fixed as part of that.

Aaron.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group