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

Qualify Object Names and temp tables

dslinn@gms.cadslinn@gms.ca Posts: 9 Bronze 2
I recently discovered the qualify object names function and that it adds brackets around my database objects, but it seems to be having a problem with temp tables. Regardless of whether I perform an INSERT INTO or a SELECT * INTO, when I run the Qualify Object Names on the sproc, I get error "SQL Prompt was unable to complete this operation. Problem areas have been highlighted" and every temp table reference has a red underline and the tooltip message is "The object [#IndividualOptionBank] could not be found in the database.". And while this is obvious (it is a temp table after all), shouldn't the routine understand that?

I am using v5.2.0.5.


Sign In or Register to comment.