TestComplete - DB Table local variable not refreshing
Hi,
I have a test case where I manage the status of a request, and everything works fine when I run it individually. The issue appears when I execute it as part of a test set: I need to use that case multiple times, but the local variable (which is a DB Table type) does not refresh. It keeps the same value from the first execution instead of updating with the new query result.
At the end of the first case, the request status changes. In my query, I filter requests so that it only returns those with a specific status (for example, status = 1). Therefore, once the status changes, the same request should no longer be returned.
Has anyone faced this situation? How can I force a local DB Table variable to refresh its data every time the test case runs inside a test set?