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.
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 |
WHAT IS ENVIRONMENT VARIABLES?and where it is used in real time scenario?
What's the difference between vbscript and vb.net?
i wrote vbscripit code in notepad i got error i am in learning stage if u ps tell me what wrong in my code my error is "object required descriptive at line one run time error"and my code is "set usernameobj=Descriptive.Create() usernameobj( "name").value="Username" set passwordobj=Descriptive.Create() passwordobj("name").value="password" set signinobj=Descriptive.Create() signinobj("name").value="sigin" browser("gmail").page("gmail").WebEdit("usernameobj").set ("enter username") Browser("gmail").Page("gmail").WebEdit("passwordobj").Set secure.Crypt.Encrypt("enter password") browser("gmail").page("gmail").WebButton("siginobj").click
Program to use input box and send even numbers into sheet1 and odd numbers into sheet2 and prime numbers into sheet3 using vbscript(QTP)?
What are keywords in the vbscript language?
Mention the rules for using option explicit statement?
a;;b;c;;;d in this string output is abcd will come how can we do that in vbscript in QTP testing?
How will you get the smallest subscript of an array in vbscript?
sunday is sunday monday tuesday wendesday sunday thursday friday saturday sunday sunday how to count no of sunday in the text file from vb? Answer me asap
what is diff between static and dynaic arrys?
Check whether given Number is Even or Odd?
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.