Forum Discussion

Logiv's avatar
Logiv
Contributor
5 years ago

Edit Database table checkpoint SQL

Hello,

 

I am using the Database table checkpoints and I cannot find how to edit or view the Custom SQL query.

 

So let's say I did the test:  Select * from Table1 

but forgot to add "where EmployeeID = id", the only way I found to add it after the checkpoint was created is to create another checkpoint, and re-doing the SQL connection string.

 

I would prefer to edit the existing query. Is it possible?

 

Thanks

  • Figured it out! In the Project explorer - Stores - DbTables, double-click the custom query and then you can press EDIT on the top right.

    Sorry, didn't know how to delete my inital post!

  • Logiv's avatar
    Logiv
    Contributor

    Figured it out! In the Project explorer - Stores - DbTables, double-click the custom query and then you can press EDIT on the top right.

    Sorry, didn't know how to delete my inital post!

    • sonya_m's avatar
      sonya_m
      SmartBear Alumni (Retired)

      Logiv Thank you for sharing the solution!

      Let's leave the post be. It can turn out really helpful if somebody else faces this obstacle.