Text completion has potential but the current implementation leaves something to be desired...

When typing SQL commands in dbisql, the text completion feature doesn't just pop and flap about and cause a visual distraction, it sometimes interprets the Enter key as "yes, I want the inappropriate suggestion you have made" instead of new line.

Hoping that text completion will prove to be useful, I've put up with this behavior for quite a while, and since most of my work is done by copy and paste from Wordpad into dbisql, it didn't bother me too much.

But now I'm in a hurry, typing adhoc requests, and I'm getting "DBA.something_I_do_not_want" instead of what I just typed, and I'm being forced to watch the screen and fix what dbisql breaks, and I am sick of it...

...so I have turned text completion off, which means "this is the last you will hear from me on this subject"

In the first screen capture below, the cursor is at the end of the last line, and I am about to press Enter to go to the next line to start the FROM clause:

before pressing enter

In the second screen capture below, I have just pressed Enter... BUT the cursor is STILL at the end of the line, and a whole bunch of unwanted crap stuff has replaced what I typed... it is not COMPLETING text, it is PADDING TEXT WITH EXTRA STUFF... I have already typed the entire column name...

...and if I do not NOTICE what text completion has done (perhaps because I am not looking at the screen while I type) and not done (it has not moved to the next line) the FROM clause that I type appears right after the column name, with no intervening space, and then I have to go back and edit the line.

after pressing enter

I suppose the third screen capture holds the clue; it shows the (default) settings, and perhaps my whining has something to do with "The Enter key completes text"... but turning that off seems to defeat the purpose behind text completion (what, I'm supposed to click the steenking MOUSE while speed typing? get stuffed! :)

text completion options

GUI features like text completion are A LOT HARDER to implement than folks think, where "implement" implies "useful" rather than "prototype".

asked 23 Jul '11, 07:38

Breck%20Carter's gravatar image

Breck Carter
accept rate: 20%

edited 23 Jul '11, 09:04


FWIW, I've never seen a GUI code completion tool that I liked. Ever. Not even a little bit. I had exactly the same complaints that you have mentioned here when I first tried Eclipse...and JBuilder.... I complained to...somebody who was responsible...at the time, and got the response that I was using it wrong and I should learn to do it their way.

I haven't used code completion, or Eclipse, or JBuilder, or anything of the sort for over 5 years, so it's probably gotten better in some products. But I prefer to check the manual in the (relatively infrequent) event that I don't know what to type.

(25 Jul '11, 10:00) Phil Mitchell
Replies hidden

Google Search's auto complete ain't bad IMO... I sometimes get all sassen-frassen-fricken-fracken when it gets too aggressive but that only happens one time out of ten... and I use it ALL the time, to see what other people have searched on relative to my query.

Generally speaking, folks can't go too far wrong copying Google GUIs :)

(25 Jul '11, 10:19) Breck Carter

I would still wonder how well Google's search completion translates from a single-line simple query to a multi-line editor with all sorts of formatting and usability requirements that are largely based on personal preference. I'm not saying it would definitely be bad. Just probably.

(25 Jul '11, 15:18) Phil Mitchell

The text completion was added because of multiple requests from users who refuse to use editors that do not have text completion. I personally find text completion useful in two contexts:

1) Using a language/library that I am not familiar with. 2) Working on a project that I am not familiar with.

If you are only working with languages and projects that you know very well, its usefulness is probably more limited. And, given that the people who have commented on this thread are "Front Page" folks, I would guess you are already pretty familiar with SQL :)

(03 Aug '11, 16:19) Eric Farrar

There are cases where the text completion will go "above and beyond" simple completion, and add additional padding with extra information (such as qualifying the table and user name). The intent is that the text completer should only add the extra information if the object, without qualification, would be ambiguous. The text completer tries to anticipate these ambiguities, and add the qualifiers for the user to avoid subsequent errors. However, there appears to be a problem with the way that the the editor is detecting this, and is being more aggressive than it needs to be. Thank you for notifying us of this.

The SQL Anywhere documentation has a page listing the Text Completion Key Shortcuts. The primary key for accepting the suggestion and closing the suggestion window is TAB. TAB is familiar key to use for this because many users will have used it for text completion in consoles. ENTER is also allowed because some other popular editor's text completion (such as Microsoft's Intellisense) allow ENTER to be used. However, recognizing that this causes frustration for some users, it can be disabled.

permanent link

answered 03 Aug '11, 16:05

Eric%20Farrar's gravatar image

Eric Farrar
accept rate: 30%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 23 Jul '11, 07:38

question was seen: 1,105 times

last updated: 03 Aug '11, 16:19