Forum Discussion

Jovani_smo's avatar
Jovani_smo
Occasional Contributor
2 years ago
Solved

Command refresh in PostgreSQL with TestExecute

I have a script where I use the refresh command to update data in PostgreSQL after doing an update and it works correctly in TestExecute 14. However, when running this script with TestExecute in vers...
Desktop Testing
  • Jovani_smo's avatar
    Jovani_smo
    2 years ago

    Hi... Sorry for the delay in answering, I was doing tests and simulations here...
    The version of TestComplete we use in development is 14.10.1042.7 x64.
    The versions of TestExecute we have running here are 14.10.1042.11 x64 and 14.91.341.11 x64...

    The problem happens on the machine that uses TestExecute 14.91.341.11 x64.
    I did tests with TestComplete 15.48.6.7 and it ran just fine...

    I managed to make it work on TestExecute 14.91.341.11 x64 by changing Refresh to Requery:

    http://docs.embarcadero.com/products/rad_studio/delphiAndcpp2009/HelpUpdate2/EN/html/delphivclwin32/ADODB_TCustomADODataSet_Requery.html

     

    Before:

    oQueryMassa.Refresh;

    After:
    oQueryMassa.Requery;

     

    Using Requery worked correctly in all versions of TestExecute. After all, the error wasn't related to PostgreSQL.

     

    Thank you for your help.

rraghvani's avatar
rraghvani
Champion Level 3

You have an unexpected window called 'Confirm' appearing after refresh method. The dialog that appears, is that from your application? You might have to automate that.

 

Jovani_smo's avatar
Jovani_smo
Occasional Contributor
2 years ago

Hello... so, the confirmation screen is showing because it is not refreshing the database... the confirmation screen shows the order number, but as the database has not been refreshed, it breaks the test.