Page 1 of 1
dbForge SQL Complete not suggesting from current database
Posted: Tue 19 Jul 2016 19:33
by jtfennig
SQL Complete is not giving me table suggestions from the current database. For example Database1 is my current database. When I "select * from" it is giving me table names from Database2. How do I get it to show me available table names from my "current" database. Must be a bug. Thanks! Using v5.1.46.
Re: dbForge SQL Complete not suggesting from current database
Posted: Wed 20 Jul 2016 05:51
by alexa
Could you please provide us a screenshot of SSMS or VS taken at that moment?
Please also check what database you have selected in the 'Available Databases' drop-down menu which is on the 'SQL Editor' toolbar.
You can reply straight to our support system at supportATdevartDOTcom
Re: dbForge SQL Complete not suggesting from current database
Posted: Sun 11 Sep 2016 23:55
by HLanger
I get that issue under these conditions:
- The autocomplete cache need to be refreshed CTRL+SHIFT+R
- There is a wrong syntax that don't let the autocomplete work properly.
- and the most annoying, is when you run a wrong syntax code and the parser just stop working and get crazy. I just copy the changes, close and open the object, past the code, and save, it mysteriously it works (I'm 100% sure that's a bug).
I hope some of these works for you, gl!.
Re: dbForge SQL Complete not suggesting from current database
Posted: Mon 12 Sep 2016 10:47
by alexa
Could you please provide us a concrete example of this including the script? A video demonstrating the issue would be also of help.
Please also specify the full name and version of the product.