SqlDbx
You are not logged in.
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)
Offline
Is there anybody out there? (You can always find a Pink Floyd lyric for every occasion ).
Offline
"One of these days" we will have a "Time" to take a look at it
Offline