language-stata icon indicating copy to clipboard operation
language-stata copied to clipboard

odbc sql command with macro

Open hudcap opened this issue 4 years ago • 0 comments

I have a sql query in an odbc command that contains a stata macro. It seems that the sql language highlighter is getting hung up on the backtick and treating everything after the backtick until the end of the file as a string.

Example: odbc load, exec("select `audit_vars' from audit_audit_comp.auditfees") dsn("wrds_pgdata-64") clear

Everything from audit_vars onwards, until the end of the file, is highlighted as a string.

hudcap avatar Jul 09 '20 03:07 hudcap