dbForge SQL Complete not suggesting from current database

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
jtfennig
Posts: 1
Joined: Thu 28 Aug 2014 16:16

dbForge SQL Complete not suggesting from current database

Post by jtfennig » Tue 19 Jul 2016 19:33

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.

alexa

Re: dbForge SQL Complete not suggesting from current database

Post by alexa » Wed 20 Jul 2016 05:51

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

HLanger
Posts: 8
Joined: Sun 11 Sep 2016 23:44

Re: dbForge SQL Complete not suggesting from current database

Post by HLanger » Sun 11 Sep 2016 23:55

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!.

alexa

Re: dbForge SQL Complete not suggesting from current database

Post by alexa » Mon 12 Sep 2016 10:47

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.

Post Reply