GETDBDATA Command
GETDBDATA is a command that can be selected from the Actions drop down list in the test step form. This command is used to fetch the entire row from the database table. It prevents multiple calls to the DB when we want to fetch the data from the same row of the table multiple times.
We can store entire row data in a variable and use it with the help of its column name.
Syntax:
Action Screen Element Parameters
GETDBDATA ——– variable name Scriptname
Example:
Action Screen Element Parameters
GETDBDATA —— x Sql_Server_Script_1
x has now stored all the data which is getting fetched by this (Sql_Server_Script_1) query.
In order to get the data from different columns we will use the syntax as below: Syntax: ${name of variable which has data [column name]}
Example: ${x[LastName]}

GETDBDATA syntax in case of multiple Database (when user is fetching data from second DB) will get changed a little bit.
Syntax:
Action Screen Element Parameters
GETDBDATA —— variable name DBSetting name : Scriptname
Example:
Action Screen Element Parameters
GETDBDATA ——- x MY SQL Settings :Sql_Server_Script_1
In order to get the data from different columns we will use the syntax as below. Syntax: ${name of variable which has data [column name]}
