Different Recordset Modes in Worksoft Certify

RECORDSET:-

Recordset is a set of records which use through variable in Worksoft certify

As we know that recordset is one of the most important features of worksoft tool and we can use it as a loop in any process it helps maintain new records as well as verify all records.

We can use recordset externally and internally in any process of certify. 

Here we will discuss how can we use recordset mode in any process externally.

DIFFERENT MODES OF RECORDSET:-

Before going to modes of recordset we need to know about how to add recordset, externally in any process of worksoft.

EXTERNAL ADDITION OF RECORDSET:-

For adding recordset externally in any process, we need to select layout in process detail window and select desirable recordset inside that selected layout. Once will select layout and recordset it will show in process detail window as below image.

after externally addition of recordset in any process, need to select recordset mode according to requirements. So recordset modes are as follows.

• Read only
• Read and update
• Append
• Clear and update

Read Only Mode: –

In this mode, the reading of recordset will start at the beginning of execution & it will work like a loop for the process because the process will execute until the last row of recordset. For example, if there are 8 records of data in recordset so the process will execute for 8 times in read-only mode.

In image A there are 8 rows of data in recordset for the process so that’s why the process was executed 8 times as we can see on the same process result in image B.

Read and update mode: –

In this mode, the reading of the recordset starts at the beginning of execution & updates the recordset at the end of execution. it also works like a loop(condition) for process because process will execute until the last row of recordset. If there are 8 rows of data in recordset so it will execute 8 times and update the data in recordset at the end of execution.

So as we can see in image A (before execution) there are 8 rows of data in recordset and it executed only 8 times as we can see in image C (Result Folder) and after execution recordset has been updated as we can see in image B.

Append Mode: –

In this mode, the write recordset starts at the end of execution. It writes new records in append mode to an existing recordset. It executes until aborts the process or exits the process. We can understand this mode in the below images.

As we can see in Image A ,before execution there is 4 sets of records in the recordset of that process, so as we are executing in append mode of recordset therefore number of rows will increase at the end of execution that we can see in below image B (Process Result After execution) and in image C (Recordset After execution)

In this process addition math operation is happening where a new number is stored in the Number variable.

As we can see in image B (Result folder) the process was executed three times and the third time was aborted so three extra rows (data) were added to the recordset that can see in Image C (Recordset after execution).

Clear And Append Mode: –

In this mode, the Write recordset starts at the end of execution and it clears all old data and writes totally new data in the recordset according to the process condition. It writes like if there is some data in recordset so it will clear and it writes new data in append mode or if there is no data in this recordset so it starts directly writing recordset with new data in append mode In that particular recordset, it executes until abort the process or exit the process. we can understand this mode in following below images.

As we can see in Image A ,before execution there is 3 sets of records in the recordset of that process, so as we are executing in clear & append mode of recordset therefore all old data will clear and new data will add at the end of execution that we can see in below image B (Process Result After execution) and in image C (Recordset After execution)

In this process addition math operation is happening where a new number is stored in the Number variable.

As we can see in image B (Result folder) the process was executed two times and the second time was aborted so two totally new rows (data) were added to the recordset that can see in Image C (Recordset after execution).