DB Testing - PRoblem with Custom and Runtime check points
I am trying to use winrunner for DB Testing ...Here, are the problems which i am facing
1. Usage of DB custom check point
Problem : For queries which return large set of data (>2kb) , it doesnt capture the expected results.
It shows <cannot capture> in the expected column , when the database query is constructed
2. Usage of DB Runtime check point
Problem : While constructing this , I am restricted to pass a query with pre-defined values for the
column - name .
SELECT TAB.Column_NAME FROM TABLE TAB WHERE (TAB.Column_NAME =3295)
If i have a situation, where i want to retrieve a large set of data > 2kb or so and would like
to pass the value to the column in Pt#2 , how do i achieve this ?
Any Hints ?
Re: DB Testing - PRoblem with Custom and Runtime check points
Try using the "db_();" functions. These give you more control over what you seem to be looking for. The query you listed will not work as is.
Here is an example that allows a variable for your concern and corrects the syntax error.
col_nameVal = 3295;
qry_ColName = "SELECT TAB.Column_NAME FROM TAB WHERE TAB.Column_NAME = " & col_nameVal & ";";