Why would runsqlscript give inconsistent results?

1 次查看（过去 30 天）

Adam Rozumalski 2016-1-22

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/264831-why-would-runsqlscript-give-inconsistent-results

评论： Geoff Hayes 2016-1-22

I get different output each time I use runsqlscript. And each time it returns an incorrect query. The ODBC datasource that the query connects to is not changing, so why would the output? Using the exec and fetch functions on the same query returns the correct result.

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Geoff Hayes 2016-1-22

Michael - what commands are you using to populate your SQL script? Please show the contents of the file, and the code used to execute the queries using runsqlscript and using the exec and fetch functions. Also, please describe the results returned from running the former. What do you mean that it returns an incorrect query? Are records being retrieved from the wrong table(s), are incorrect fields being returned, etc.?

请先登录，再进行评论。

请先登录，再回答此问题。