Refresh the value of a variable

Hello,

I have a variable which stores the value of a Database field called 'Status'. I fetch that value by using the connection string and then reading the value from a result set. During the Test run, the Status keeps changing, and I have to check the status and then move ahead with the tests. 

After first block of test run, status changes from 1 to 3

After second block of test run, status changes from 3 to 7

After third block of test run, status changes from 7 to 13.

Every time I reuse the variable to compare the value of it, it remains the same as in the beginning, but I was expecting it to change from 1 to 3 to 7 to 13, because the database table has the required status.

I'm not sure when I reuse the variable, it makes a fresh call to the DB and gets the status. Looks like it's still fetching the old value.

Any suggestion would really be appreciated

Thank you

Abhi