SqlDbx Forum

jvall

Member

switch off autocomplete with $(var)

How can I deactivate the use of $() (I don't know what is that) in autocomplete mode (IntelliSense)?
And I don't want to deactivate IntelliSense at all.

Last edited by jvall (2016-05-21 18:32:22)

sqldbxhelp

Administrator

Re: switch off autocomplete with $(var)

If you do not use script variables I am not sure how you can have issues with them.
Can you please explain or provide example.

jvall

Member

Re: switch off autocomplete with $(var)

Script variables is the name, Ok Thanks.
The problem is that they are the first option for autocomplete, so I have to move the selection to the second option of the menu. That makes it slow.
Also I have to mention that script variables appears in the autocomplete menu even if I did't define them.

Last edited by jvall (2016-05-22 16:21:24)

jvall

Member

Re: switch off autocomplete with $(var)

If you do not use script variables I am not sure how you can have issues with them.
Can you please explain or provide example.

I have problems because I don't define a script variable and  intellisense converts everything that I recently wrote to a reference of a script variable.

sqldbxhelp

Administrator

Re: switch off autocomplete with $(var)

Can you provide script example which causes you problems.

jvall

Member

Re: switch off autocomplete with $(var)

There are other examples but this is one of them:

declare @param1 $(int)

When I start to write "int" and press space (or any key to accept the autocompleted word) the autocomplete function puts $(int). And I just want to write the reserved word "int", that is almost always the second option.

Thank you!

sqldbxhelp

Administrator

Re: switch off autocomplete with $(var)

What database you connect to?
This looks very unusual to me.
Why would you declare variable with the name like this?

jvall

Member

Re: switch off autocomplete with $(var)

Sorry, I'm connect with Sybase but thats not the point. That was a bad example because it uses a variable declaration in sybase.

Another example, this is what I want:

create table TEST
	( column1 int not Null,
	  column2 char
	)
go

this is what I get:

create table TEST
	( column1 $(int) $(not) $(Null),
	  column2 $(char)
	)
go

sqldbxhelp

Administrator

Re: switch off autocomplete with $(var)

This is really very strange.
The only way I can see how it can happen is that somewhere in your
script you have something like this:

$define int
$define char
$define not
$define null

What do you see when you select menu Connection->Edit Script Variables?

jvall

Member

Re: switch off autocomplete with $(var)

No I don't have that type of "define".

This is the list (the Value column is empty):

name
sysobjects
drop
spsif_consulta_lotes_infobps
@terminal
smallint
@inst_term
int
@plaza_term
char
@institucion_destruye
@plaza
@boveda
@fecha_inicial
datetime
@fecha_final
@especimen
@estado_fisico_origen
@institucion_origen
@relacion_destr
@fecha_registro_destr
@folio_sistema_destr
....

And many others more. Total of  174

sqldbxhelp

Administrator

Re: switch off autocomplete with $(var)

Something causes these variables to be created.
Can you please email scripts you have opened for this connection
to support at sqldbx together with SqlDbx version you use.

jvall

Member

Re: switch off autocomplete with $(var)

I've already sent the email.

I do a test with a new connection where the scripts variables are empty, I know now that this variables are created when I excecute a creation of a stored procedure. Thats the problem, but my stored procedure obviusly doesnt $define variables by this way.