Forum Discussion
AlexKaras
10 years agoChampion Level 3
Hi Douglas,
If I understood your question right...
It looks like you are using ADO to excute every single query. If this is correct, then indeed, ADO cannot execute queries in a batch and your current approach is the only possible one.
However, every database has a command-line utility designed to execure SQL statements in a batch (for example, in SQL server it is called sqlexec). So, you may call the relevant utility from your test code, provide it with the file name and analyze the returned exit code and console output when it completes the work.
See http://support.smartbear.com/viewarticle/8963/ for the sample of how to wait for the command-line utility to complete and get its output.
If I understood your question right...
It looks like you are using ADO to excute every single query. If this is correct, then indeed, ADO cannot execute queries in a batch and your current approach is the only possible one.
However, every database has a command-line utility designed to execure SQL statements in a batch (for example, in SQL server it is called sqlexec). So, you may call the relevant utility from your test code, provide it with the file name and analyze the returned exit code and console output when it completes the work.
See http://support.smartbear.com/viewarticle/8963/ for the sample of how to wait for the command-line utility to complete and get its output.
Related Content
- 5 years ago
- 8 years ago
- 5 years ago