Home » DbVisualizer Forums » DbVisualizer » DbVisualizer - Support

Thread: Autocomplete field list not working for non-current database

This question is answered. Helpful answers available: 2. Correct answers available: 1.


Permlink Replies: 7 - Pages: 1 - Last Post: Jun 21, 2011 8:03 AM Last Post By: Roger Bjarevall
Vince Swann

Posts: 169
Registered: 03/27/07
Autocomplete field list not working for non-current database
Posted: Dec 8, 2010 5:15 PM
 
   thread.click_reply Reply
There seems to be a problem in the ctrl-space object name autocompletion when using fully-qualified database names.

When you reference a table in the current database you can see the field list whether or not you reference it using the fully-qualified databasename.schemaname.objectname syntax

However, referencing another database on the same server using the fully-qualified databasename.schemaname.objectname syntax fails to show the field list unless you also remember to change the current database in the dropdown list.

I do a number of cross-database queries so have to change the current database multiple times when developing if I want to use autocomplete and then need to remember to set it back to the one I want before execution.

It would be good if the autocomplete could pick out the database from the 3-part naming syntax and show the autocomplete field list for tables correctly.

Even better enhancements would be to recognise the 4-part naming syntax for linked servers and to look upwards for the last USE statement in the SQL if the database is not explicitly stated.

I've attached some screenshots for clarification. In each of these screenshots I've just pressed ctrl-space to open the autocomplete list.

The screenshots all use the following test databases and tables:
CREATE DATABASE tstdb1
GO
USE tstdb1
GO
CREATE TABLE db1tbl1 (
id TINYINT NOT NULL IDENTITY PRIMARY KEY
, data CHAR(10)
)
GO
CREATE DATABASE tstdb2
GO
USE tstdb2
GO
CREATE TABLE db2tbl1 (
id TINYINT NOT NULL IDENTITY PRIMARY KEY
, data CHAR(10)
)
GO
I'm using SQL Server 2008 via the jTDS driver.
Roger Bjarevall


Posts: 5,173
Registered: 12/17/04
Re: Autocomplete field list not working for non-current database
Posted: Dec 10, 2010 10:45 AM    global.in_response_to.tooltip in response to: Vince Swann
 
   thread.click_reply Reply
Hi Vince,

Thanks for the detailed post.

We will check into this.

Best Regards

Roger

Edited by: Roger Bjarevall on 2010-dec-10 10:46. Sorry, "Martin" should be "Vince"
Vince Swann

Posts: 169
Registered: 03/27/07
Re: Autocomplete field list not working for non-current database
Posted: Dec 13, 2010 12:36 PM    global.in_response_to.tooltip in response to: Vince Swann
 
   thread.click_reply Reply
Thanks for looking into it. Let me know if you need more information.
Regards,
Vince
Vince Swann

Posts: 169
Registered: 03/27/07
Re: Autocomplete field list not working for non-current database
Posted: May 10, 2011 1:41 PM    global.in_response_to.tooltip in response to: Vince Swann
 
   thread.click_reply Reply
Confirmed still broken in EAP 720.1638.
Hans Bergsten


Posts: 1,588
Registered: 10/11/06
Re: Autocomplete field list not working for non-current database
Posted: May 11, 2011 9:35 AM    global.in_response_to.tooltip in response to: Vince Swann
 
   thread.click_reply Reply
Hi,

Thanks for reporting this. A fix has been implemented and will be included in the next EA, to be released shortly.

Best Regards,
Hans
Roger Bjarevall


Posts: 5,173
Registered: 12/17/04
Re: Autocomplete field list not working for non-current database
Posted: May 11, 2011 10:20 AM    global.in_response_to.tooltip in response to: Vince Swann
 
   thread.click_reply Reply
Hi,

This is now fixed in the DbVisualizer 720.1640 EA version.

Regards

Roger
Vince Swann

Posts: 169
Registered: 03/27/07
Re: Autocomplete field list not working for non-current database
Posted: Jun 3, 2011 4:30 PM    global.in_response_to.tooltip in response to: Roger Bjarevall
 
   thread.click_reply Reply
Hi Roger,

Thanks - I can confirm the bug I reported is now resolved.

I have just noticed the field list still doesn't show if the alias points to a linked server (using the server.database.schema.table syntax) but that's a far less common activity so less of an issue.
Roger Bjarevall


Posts: 5,173
Registered: 12/17/04
Re: Autocomplete field list not working for non-current database
Posted: Jun 21, 2011 8:03 AM    global.in_response_to.tooltip in response to: Vince Swann
 
   thread.click_reply Reply
Hi,

Just to inform that this is now fixed in the latest DbVisualizer 8.0 version.

Regards

Roger

Point your RSS reader here for a feed of the latest messages in all forums