Exploratory Community

ODBC Dislikes Comments

#1

I notice that if I paste in SQL code for an ODBC connect, I receive errors if there are any comments in the script

for example the “–” denotes a comment and is not run as code. I can run the SQL fine outside of Exploratory with – in.

Select
DX.VISIT_KEY

FROM DIAGNOSIS_ENCOUNTER_ALL DX

WHERE
DX.VISIT_DIAGNOSIS_IND = 1 
--and DX.VISIT_KEY = '999'

#2

This is a bug, we’re looking into it, should be fixed in the next patch!

#3

Thanks! Would definitely save lots of time as I copy and paste. Keep up the good work!

#4

Thank you for reporting the issue and we will include the fix in the next patch

As a workaround, could you try adding a new line feed after the comment line by hitting enter key on the editor?

So

Select
DX.VISIT_KEY

FROM DIAGNOSIS_ENCOUNTER_ALL DX

WHERE
DX.VISIT_DIAGNOSIS_IND = 1 
--and DX.VISIT_KEY = '999'

Becomes

Select
DX.VISIT_KEY

FROM DIAGNOSIS_ENCOUNTER_ALL DX

WHERE
DX.VISIT_DIAGNOSIS_IND = 1 
--and DX.VISIT_KEY = '999'

#5

Same error with adding a new line