Question Re: Interactive SQL auto-fill in Technology Q&A

Interactive SQL auto-fill

Former Member — Tue, 27 Nov 2012 13:39:13 GMT

Is it possible to turn off the auto-fill feature in Interactive SQL? It is more annoying than valuable.

SPC

Re: Interactive SQL auto-fill

jeff_albion — Tue, 27 Nov 2012 14:16:31 GMT

This is controlled by deselecting the following option in the Options panel:

Tools -> Options...
Editor -> Text Completion
[X] Open automatically

As noted in the options, you can still use "CTRL+Space" to bring up the syntax suggestion window manually.

Re: Interactive SQL auto-fill

Former Member — Wed, 28 Nov 2012 17:34:37 GMT

Maybe I need to update the software, but the Tools -> Options does not have this control. I have Tab Placement, Fast Launcher, Show Tips on startup, and Show welcome window on startup.

SPC

Re: Interactive SQL auto-fill

VolkerBarth — Wed, 28 Nov 2012 18:52:58 GMT

So what SA version are you using?

Re: Interactive SQL auto-fill

Former Member — Thu, 29 Nov 2012 15:12:26 GMT

12.0.1.3579

Re: Interactive SQL auto-fill

jeff_albion — Thu, 29 Nov 2012 16:18:23 GMT

Ah - I believe you're currently in Sybase Central, not Interactive SQL.

In Sybase Central, while you're editing SQL (e.g. a stored procedure), you can go to "File" -> "Customize Editor...", which gives you the same "Editor" category with the same options as I listed above in Interactive SQL.

Re: Interactive SQL auto-fill

Former Member — Thu, 29 Nov 2012 16:22:04 GMT

Thanks, Jeff. You are right.

Re: Interactive SQL auto-fill

Breck_Carter — Thu, 29 Nov 2012 16:22:20 GMT

I thought I was losing my MIND, I could not find ANY of that stuff you mention, anywhere, in the ISQL Tools Options!!!

Then I realized you are looking at the Sybase Central Tools Options... try launching ISQL separately.