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.
- 2 Answers
- 6908 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
Can automation testing find ssame no. of bugs what we can find by manual testing?
Which operator can be used to do an xor operation in vbscript?
Mention characteristics of sub procedures?
What is byref and byval parameters in vbscript?
I have attended Anovatek Software QTP interview. They will give us computer and one web based application with QTP. We have to automate some records (already updated records or new records) using QTP Data driven testing. But we should use for loop? Can any one know how to do data driven testing using For loop?
write a vb script to display the code "vbscripting" alphabet by alphabet(i e 1st v then b and up to g)
Can someone please tell me what poor design in a relational database (not the layout or style) is and how it can be avoided? PLEASE...im desperate.
Mention what is the use of option explicit in vbscript?
HOw we can apply web service checkpoint in QTP 9.5? I tried it out with net connection also. But not getting success.
How to check the particular window is exist or not with out using check points
write a vbscript for finding the sum of the numbers from 1- 50
How to identify column in VSFlexgrid? My VSFlexgrid window is identified as 'Active X Control'
ASP 
