Page 1 of 1
Temp table suggestions don't work if create table statement is removed from editor
Posted: Wed 17 Jun 2020 21:57
by jeff.vial
I've noticed that column suggestions for temp tables only work if I still have the create table statement for the temp table still in the editor, uncommented. Once I remove the create statement, suggestions no longer work; it's like the temp table has disappeared from the metadata despite still being queryable. This is very inconvenient as the only way to get suggestions when writing select statements with a temp table is to keep the create statement in the editor, which requires me to highlight any select statement I want to run. Is this expected behavior?
Re: Temp table suggestions don't work if create table statement is removed from editor
Posted: Thu 18 Jun 2020 05:34
by alexa
Could you please provide us the full name of the product along with its version?
Re: Temp table suggestions don't work if create table statement is removed from editor
Posted: Thu 18 Jun 2020 15:14
by jeff.vial
SQL Complete 6.5.23
Re: Temp table suggestions don't work if create table statement is removed from editor
Posted: Fri 19 Jun 2020 07:38
by alexa
Thank you for the reply.
Such a behavior is by design.
The temp table definition needs to be present in the script in order to be offered in the suggestion list.
Re: Temp table suggestions don't work if create table statement is removed from editor
Posted: Fri 19 Jun 2020 15:09
by jeff.vial
Thank you for the response.