cancel
Showing results for 
Search instead for 
Did you mean: 

Run SQL file

SOLVED
Occasional Contributor

Run SQL file

My problem is:

I have a very large sql to run, and my idea was to externalize this sql to an external file and just run it through testcomplete is there any way to accomplish this? my database is oracle my application is descktop

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Staff

Re: Run SQL file

So the SQL you want to execute, can you run it say from a batch file outside of TestComplete?. If so you one way is to add your batch file as a TestedApps object and run it:

 

TestedApps.yourBatch.Run() 

 

View solution in original post

3 REPLIES 3
Staff

Re: Run SQL file

please review similar posting in the community https://community.smartbear.com/t5/TestComplete-Functional-Web/How-to-run-a-sql-file-querys/td-p/880...

 

I would also make sure that you can connect to the database from the machine where TestComplete is installed say from an odbc datasource configuration setup

Occasional Contributor

Re: Run SQL file

I read that but i don't understand how to do . 

 

I can connect to the database, but to run large sql is a lot of work to do with the code (because it needs the string to be in a specific format to be recognized with delphiscrit for the string to be accepted) so the idea of ​​externalizing the file

Highlighted
Staff

Re: Run SQL file

So the SQL you want to execute, can you run it say from a batch file outside of TestComplete?. If so you one way is to add your batch file as a TestedApps object and run it:

 

TestedApps.yourBatch.Run() 

 

View solution in original post

New Here?
Join us and watch the welcome video:
Final Interview in the Series
API_testing_mistake#7