Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7774 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
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 operate webobjects in a webpage using getobject function and then using generic methods?
what is the object hyrarchy in QTP for a web based application
Explain the adodb.stream class?
Explain some uses of vb script?
How to find the font in qtp. Scenario:After entering the username and passwd you will be navigate into the "welcome:Username" page.Now I want to extarct font for this message.
Which operator is used to concatenate the 2 values in the vbscript language?
What is Procedure or Subroutine in VB Script?
Is vbscript a case-sensitive or case-insensitive?
How will you convert a given number to long in vbscript?
Explain about vb script?
about vb scripting programs this type of all question& answers
What are keywords in the vbscript language?
can anyone send me a vb scripts code for clicking on a link and coming back on home page again does the same for many links on a web page.
Mention what if you do not specify anything when you call a procedure?
