Forum Discussion

Jovani_smo's avatar
Jovani_smo
Occasional Contributor
2 years ago

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
2 years ago

Got it.

 

If the value has been updated in the database, has it not been reflected in the application straight away? Calling a Refresh on the application, I don't think will retrieve the updated data. 

 

  • Jovani_smo's avatar
    Jovani_smo
    Occasional Contributor
    2 years ago

    Well that's right... I'm calling the Refresh method just to update the value in the application... and it works fine when I use it with TestExecute 14, the problem happens when I use it with TestExecute 15.