SqlDbx Forum

blackviper666

Member

Intellisense Issue

Hi All,

Please point me in the right direction if this has already been posted (I cannot find it) because it seems like an issue which would have reared it's head earlier.

Using either ODBC or Sybase Anywhere I get the following issue. Basically using 'if' seems to break the intellisense.

If I type -
    select c.name from contact c

the intellisense works correctly to find the field 'name'.

If however I type (poor example but you get the idea) -
    select 'name' = if c.name = 'this' then 'that' else 'something' endif from contact c

the intellisense no longer recognizes my alias and will not derive the field 'name' and in fact will stop working for the rest of my query.

Any ideas?

Last edited by blackviper666 (2010-12-08 01:14:33)

sqldbxhelp

Administrator

Re: Intellisense Issue

Yes, you are right if does break Intellisense in this scenario.
We will have to take a look and see how it can be fixed.

blackviper666

Member

Re: Intellisense Issue

Not sure whether I should start a new topic for this but as it is along the same lines thought I would add to this. As well as 'if' breaking the intellisense it seems that 'is' does the same thing (is null or is not null)

If I execute the query -

  select new_name = a.name from contact a

the intellisense works correctly.

If however I type -

  select new_name = case when a.name is null then 'New Name' else a.name end from contact a

the intellisense stops working. It appears that as soon as the word 'is' is typed the intellisense breaks.

sqldbxhelp

Administrator

Re: Intellisense Issue

This is a bug. It will be fixed in a next release.