Forum Discussion

paulohg6's avatar
paulohg6
Occasional Contributor
5 years ago
Solved

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

  • DWalsh's avatar
    DWalsh
    5 years ago

    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() 

     

3 Replies

    • paulohg6's avatar
      paulohg6
      Occasional Contributor

      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's avatar
        DWalsh
        Moderator

        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()