DB CheckPoint Problem
I am having trouble creating a DB checkpoint for the following test scenario.
Midway through my keyword test a valid record is retrieved from the DB using the following query:
select top 1 substring(t_reference, 3, 10) from tickets where t_complete = 0 and t_on_hold = 0 and t_cancelled = 0 and t_status=600
order by t_date_time_issued desc
This record is then used to set a variable and to complete a number of operations using my software.
At the start of my test there is a flag in the database which is set to "0" for this record.
At the end of the keywordTest one of the database checks i need to perform is to verify the flag has been set to '-1'.
Can anyone advise me on how i can create this checkpoint?