Hi Statalist,
The following lines runs perfectly:
Code:
odbc load, exec("SELECT NDRLD_View.dbo.xvw_tblPractice.PracticeLSPN FROM (NDRLD_View.dbo.xvw_tblPractice INNER JOIN NDRLD_View.dbo.xvw_tblPracticeUser ON NDRLD_View.dbo.xvw_tblPractice.PracticeID = NDRLD_View.dbo.xvw_tblPracticeUser.PracticeID)") dsn("NDRLD_View")
But when I break it to two lines I get error messages which is "unmatched quote":
Code:
odbc load, exec("SELECT NDRLD_View.dbo.xvw_tblPractice.PracticeLSPN FROM ///
(NDRLD_View.dbo.xvw_tblPractice INNER JOIN NDRLD_View.dbo.xvw_tblPracticeUser ON NDRLD_View.dbo.xvw_tblPractice.PracticeID = NDRLD_View.dbo.xvw_tblPracticeUser.PracticeID)") dsn("NDRLD_View")
Could you please let me know how I can break it to two lines or more? I need to run a very long codes inside "exec".
Comment