Page 1 of 1
auto-table name completion prefixes with database.schema
Posted: Tue 25 Apr 2017 23:33
by HockeyFan77
After the most recent update to 5.6.146, when SQL Complete automatically completes a table name, it also prefixes the table name with the database-name.schema-name. Is there a way to turn this off?
Example:
I type "select * from myT" and let SQL Complete finish the statement with "select * from myTable".
After completion, I get "select * from myDatabase.mySchema.myTable".
Re: auto-table name completion prefixes with database.schema
Posted: Wed 26 Apr 2017 07:34
by alexa
Could you please provide us a concrete query? A video or screenshots would be also of help. Are you using a linked server?
You can send a reply straight to our support system at supportATdevartDOTcom and alexaATdevartDOTcom .
Re: auto-table name completion prefixes with database.schema
Posted: Wed 26 Apr 2017 15:33
by HockeyFan77
I sent an animated .gif showing the behavior I'm seeing.
Thanks for looking into this.
Re: auto-table name completion prefixes with database.schema
Posted: Thu 27 Apr 2017 12:40
by alexa
Thank you for the reply.
We will fix this issue in the next product build and will notify you once it's available for downloading.
Re: auto-table name completion prefixes with database.schema
Posted: Thu 27 Apr 2017 13:49
by HockeyFan77
That's great news. I'm glad you folks were able to reproduce the error. (well, maybe not error, but you get my meaning)
Thanks again!
Re: auto-table name completion prefixes with database.schema
Posted: Wed 24 May 2017 21:25
by HockeyFan77
I just wanted to post a follow-up and let you know the latest version 5.6.152 solves the problem.
Excellent work.
Oh, and I'm telling anyone who will listen what a wonderful tool this is.
Thanks again!
-Mark
Re: auto-table name completion prefixes with database.schema
Posted: Thu 25 May 2017 07:52
by alexa
Thank you for updating us on this issue. Please let us know if any questions arise.