SqlDbx Forum

tbenci

Member

IntelliSense Issue with complex SQLs

Good morning all,

USING LATEST VERSION 4.12 Professional

Using this SQL as an example (and I realise that it is difficult using SQLs that others can't possibly run ) I find that when I add the CASE statements to the SELECT clause the IntelliSense stops working

SELECT
  t.task_no AS TaskNumber,
  t.activity_due_date AS DueDate,
  t.note AS Note,
  CASE isnull(t.is_completed_flag,'') WHEN 'C' THEN 'true' ELSE 'false' END AS CompletedFlag,
  CASE isnull(sc.company_name,'') WHEN '' THEN trim(replace(sc.surname + ', ' + sc.title + ' ' + sc.name,'  ',' ')) ELSE sc.company_name END AS SalespersonDisplayName

FROM
  Mkt_Task AS t
  JOIN contact AS sc ON sc.contact_code = t.salesperson

WHERE
  t.pros_cust_id = 'CREMINM1011'

ORDER BY
  t.task_no,
  t.

If I comment out the CASE lines its works again. Is the structure of the CASE statements causing this (given that they are in one line and not multi-lines or is this an issue in the editor that can be looked at? It is a real nuisance when working with complex SQLs (the one above is nowhere as complex as they can get ).

In the example above the t. in the ORDER BY does not result in the field name pop up working.

Cheers
Tony

Last edited by tbenci (2016-01-10 20:41:37)

tbenci

Member

Re: IntelliSense Issue with complex SQLs

Is there anybody out there? (You can always find a Pink Floyd lyric for every occasion ).

sqldbxhelp

Administrator

Re: IntelliSense Issue with complex SQLs

"One of these days" we will have a "Time" to take a look at it