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
- 7756 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
What is event handling in vbscript?
What are string functions in vbscript?
Which keyword is used to declare a variable in the vbscript language?
Program to use input box and send even numbers into sheet1 and odd numbers into sheet2 and prime numbers into sheet3 using vbscript(QTP)?
How should i Create Email invite with server-side Coding?
how to write a vb script in QTP for yahoo registration form, i want to check the performance also like performance test, stress, load test like that.
when we use filter funtiom invb script(QTP)
How will you get a combined string from array of string in vbscript?
Explain about scrrun.dll?
How to use QTP Object in .vbs(vbscript file) file Ex: Browser().., wait(), exist() and etc...
did any one attended interview in applabs if you had gone through plz tell me the procedure
Mention if qtp generates vbscript code as we record actions, can't it possible to directly write using vbscript code when qtp does the same thing too?
give me any information abou vb script books learn quckly
How will you get the exponent of the given number in vbscript?
What is the use of the formatdatetime function in the vbscript language?
