Ask a Question

Run SQL file

SOLVED
paulohg6
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
DWalsh
Moderator

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
DWalsh
Moderator

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

paulohg6
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

DWalsh
Moderator

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

cancel
Showing results for 
Search instead for 
Did you mean: