Why would runsqlscript give inconsistent results?
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
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 comentario
Geoff Hayes
el 22 de En. de 2016
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.?
Respuestas (0)
Ver también
Categorías
Más información sobre Reporting and Database Access en Help Center y File Exchange.
Productos
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!