In QTP how to insert a data base check point for web based application and sim

In QTP how to insert a data base check point for web based
application and simultaneous link to code in expert veiw.
hw to retrieve a data(single coulumn from server) that
matches with inserted value manually or exported from excel
sheet.

Question Posted / gayatri

2 Answers
7734 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

In QTP how to insert a data base check point for web based application and simultaneous link to co..

Answer / gayatri

I have coded this, can anyone plz rectify and send

Dim con, rs, username1
Set con=Createobject("ADODB.Connection")
Set rs = CreateObject("ADODB.Recordset")
con.connectionString="Drivers={SQLServer};
DSN=<dsn_name>; OPTION=0; PWD=konnects; PORT=<port name>;
SERVER=<server name>; UID=konnects"
con.open
rs.open SQL ,conn
SQL= "select user_name from t_member"
Set rs=con.Execute(SQL)
DbTable("DbTable").Check CheckPoint("DbTable")
on error resume next
while rs.EOF
Do Until username1=user_name
username1=rtrim(rs.fields("user_name"))
msgbox username1
If username1=username Then
Msgbox " User name already exist try another"
Username=inputbox("Username")
msgbox User_name
else
rs.MoveNext
end if
loop
wend
rs.close
con.close
Set rs = Nothing
Set con = Nothing

Browser("").Page("page name").WebEdit("UserName").Set
UserName

Is This Answer Correct ?

1 Yes

0 No

In QTP how to insert a data base check point for web based application and simultaneous link to co..

Answer / shiva shankar

Even i have stuck with this database check point have you
got the solution for this how to insert a data base check
point pleace could you mail to my id
shiva_uma2003@rediffmail.com thaks in advance

Is This Answer Correct ?

1 Yes

0 No

Post New Answer