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 |
Explain what is loose binding? Why is it not a good practice to use it?
* ** *** Please write a code to get output like above diagram? ple explain as it how the code works?
How to find a latest file from any folder
Consider there are objects in a webapp which are identified by QTP. Suppose you know only the logical name of a object(absolutely nothing else about it). Which approach will you take to find the "micClass" of the object(You can't use Object Spy, or can't add the object in repository)?
How will you get the largest subscript of an array in vbscript?
What is dictionary object in vbscript? Explain?
Could Anybody Please tell me What is the script for Find 3rd Largest element in the Array without using a SORT function int Find(int arr[], int size); Thanks in Advance..
about vb scripting programs this type of all question& answers
pls tell me which is good book or site for vbscript?
Which object is used to work with the excel sheets in the vbscript language and what statement is used to create this object?
How will you get the natural logarithm of the given number in vbscript?
What are the differences between Visual Basic, VBA and VBScript? When would it be appropriate to use one as opposed to another?