Home » DbVisualizer Forums » DbVisualizer » DbVisualizer - Support

Thread: Auto completion


Permlink Replies: 4 - Pages: 1 - Last Post: Dec 1, 2009 4:24 PM Last Post By: Freewater
Freewater

Posts: 59
Registered: 11/04/09
Auto completion
Posted: Nov 4, 2009 2:28 PM
   thread.click_reply Reply
Hi,

I think this is a bug:

Auto completion does not come up anymore if "key join" is used. "Key join" is Sybase IQ syntax for "inner join on all primary key columns of the table".

Example:
select *
from dbo.f_deal d
key join dbo.d_customer f


Regards,

Roger Bjarevall


Posts: 5,042
Registered: 12/17/04
Re: Auto completion
Posted: Nov 4, 2009 10:30 PM    global.in_response_to.tooltip in response to: Freewater
   thread.click_reply Reply
Hi,

You say that it doesn't come up "anymore". Did it use to work? I just tried and the AC popup is displayed properly with 6.5.10. The "key" part should not be an issue as it is "join" that triggers what objects will be listed in the popup.

Regards

Roger
Freewater

Posts: 59
Registered: 11/04/09
Re: Auto completion
Posted: Nov 6, 2009 2:42 PM    global.in_response_to.tooltip in response to: Freewater
   thread.click_reply Reply
Roger,

I wasn't specific enough:

Auto completion for tables does indeed come up with either syntax, for example with cursor on the first letter of the second table name.

But if the cursor is on the asterisk (blinking on the left side of it) in:

select *
from rmdb_dbo.vda_geschaeft_netto dg
key join rmdb_dbo.vfa_geschaeft_netto fg

then Auto completion for columns will not come up with Ctrl-Space. It does, though, if the word "key" is changed to "inner" or "left". (DbVis 6.5.10).

Regards,
Börries Wendling
Roger Bjarevall


Posts: 5,042
Registered: 12/17/04
Re: Auto completion
Posted: Nov 9, 2009 10:48 AM    global.in_response_to.tooltip in response to: Freewater
   thread.click_reply Reply
Börries,

Got it. Thanks!

This will be fixed in the next version.

Best Regards

Roger
Freewater

Posts: 59
Registered: 11/04/09
Re: Auto completion
Posted: Dec 1, 2009 4:21 PM    global.in_response_to.tooltip in response to: Freewater
   thread.click_reply Reply
[deleted] need to elaborate this...

Edited by: Freewater on Dec 1, 2009 4:23 PM

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