How to database testing by manualy?in my db having 100
records when i am retriving the data from db it shows in
frent end 30 records how to find bug using QTP?plz Exp
realtimers (Chandana)
Answers were Sorted based on User's Feedback
Answer / saravanaraja
You can Copy & Paste to QTP:
Dim con,rs,ex,a,b,i
Set con=createobject("adodb.connection")
Set rs=createobject("adodb.recordset")
con.open"provider=sqloledb.1;server= ;uid= ;pwd= ;database=
"
rs.open"select count(column name) from table",con
Set ex=createobject("Excel.Application")
Set a=ex.workbooks.open("path of the Excel")
Set b=a.worksheets("sheet1")
i=1
Do while not rs.eof
b.cells(i,1).value=rs.fields("column name")
rs.movenext
i=i+1
loop
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / sesha reddy
plz any one can send answer ,only reading the answers is
not godd friends .plz try to write the answers
from
sesha reddy
Is This Answer Correct ? | 3 Yes | 2 No |
Answer / t.sunil kumar
Goto Insert>>checkpoint>>database checkpoint>>wizard will
open >> select the select sql statement manually>> click on
Next>> sepecify the connection string>> enter the query you
want. so that all the data available in the database will
appear in the table format. so that compare the data with
the user interface so that you can find the error in the
database.
plz let me know if there is any wrong in my answer.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / ashok
Using QTP ,and make appropriates db connection and Query to
get a data in Record Set from data base and compare that
data with front end dable to find bugs.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / chandana
Dear Ashok u told the processor ? can u explain me in detail
with steps Plz (chandana)
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / ashish srivastava
Hi All,
As per your question i would like to suggest that make sure
that your are passing the same query from the from end as
you are using it in the back-end
as per the question your database having 100 records ,so
make sure that the query ur passing should not have any
"WHERE" AND JOINS statements in the query . If you have then
the Result will be filter and you will get the record
matching to the criteria in the query
FOR USING IT IN QTP PLS write the below code
Dim connect, recset
connect=CreateObject("ADODB.Connection")
recset=CreateObject("ADODB.RecordSet")
connect.Open"Provider=SQLDB1,Userid="Your ID",
Password="Your Password",Database="Your Database"
recset.open "Select Count(*) from your table name",connect
msgbox recset
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / lotr
Good reply Sunil. I guess they must have replied if that
solution worked or not !!
Is This Answer Correct ? | 0 Yes | 1 No |
Hi All, issue is related to handling pop up script generated in IE, and run on mozilla. In App Under Test, when we get the alert pop ups, we just click ok button. if we need to run the same code on mozilla it will not identify . so we will check browser if browser(*).dialog(IE object).exits browser(*).dialog(IE object).winbutton(OK).click else 'by default mozilla browser(*).dialog(mozilla object).page(*).webbutton(OK).CLICK END IF But my qustion is. Do we write the above piece of code where ever we get such kind of pop ups from the application like alert pop up, confirmation pop up.... OR do we have any other alternative way to do this by using any functions in Recovery Scebarios? If Any of u know idea please do help me in this regard. or send answer to kravimb@gmail.com
In a flight window we have to enter the name and meal request for every passenger.In that window if we give Total passengers=1 then the Psngr1 name field and psngr1 meal request field will reflects.if we give Total passengers=2 then Psngr1 name field and psngr1 meal request field,Psngr2 name field and psngr2 meal request field and so on. how we can handle this scenerio thru Descriptive programming?
Write a script to print below pattern 5 4 3 2 1 5 4 3 2 5 4 3 5 4 5
Hi I'm a beginner in QTP. So far I'm ok with Descriptive but stuck while implementing Hybrid Frame work. 1. I have created a Keyword file with .vbs ext set home=description.create home("title").value="Welcome to feests" set reglink=description.create reglink("name").value="register yourrestaurant / take away" set fbusname=description.create fbusname("name").value="business_name" set dispname=description.create dispname("name").value="display_name" set restchkbox=description.create restchkbox("name").value="restaurant" set cuiscate=description.create cuiscate("name").value="cuisine_categery1" set addline1=description.create addline1("name").value="address_line1" set pstcode=description.create pstcode("name").value="address_postcode" set cntry=description.create cntry("name").value="address_country" set mlandno=description.create mlandno("name").value="landline_no" set emailadd=description.create emailadd("name").value="email" 2. I have created an Function Library file as follows Function launch() bro="C:\Program Files\Internet Explorer\iexplore.exe" url="http://www.feests.com/" invokeapplication bro&" "&url Browser(home).page(home).Link(reglink).click End Function Function restregistration(karthik, teja, Ameerpet, UK) Browser(home).page(home).WebEdit(fbusname).set "karthik" Browser(home).page(home).WebEdit(dispname).set "teja" Browser(home).page(home).WebCheckBox(restchkbox).set "ON" Browser(home).page(home).WebList(cuiscate).Select "Indian" Browser(home).page(home).WebEdit(addline1).set "Ameerpet" Browser(home).page(home).WebEdit(pstcode).set "UK" Browser(home).page(home).WebList(cntry).select "United Kingdom" Browser(home).page(home).WebEdit(mlandno).set "023775347" Browser(home).page(home).WebEdit(emailadd).set "email@gmail.com" End Function 3. This is how I have called the keywords and Functions in QTP executefile"C:\Documents and Settings\karthik\Desktop\keywords.vbs" executefile"C:\Documents and Settings\karthik\Desktop\functions.vbs" launch restregistration karthik, teja, Ameerpet, UK, "email@gmail.com" Now the issue is, I'm trying to enter the email ID in WebEdit field. But I dont know what is the mistake I did, if I run the script in QTP it is showing following error Error: Expected identifier Line (2): "executefile"C:\Documents and Settings\karthik\Desktop\functions.vbs"". Can someone help me fix this, please!!?
what is the use of automation frame work ??(QTP)
Hi all, I am New to QTP . I am Now in critical situtaion. I want to know How to create our own object respository for our application. please say the answer with example.
How can I replace all the text from the QTP script with some other text.
Give me some real time point of way where exactly we can conduct audits?
What is recovery scenario manager? When you go for recovery scenario manager? Tell me one scenario were your used recovery scenario in your project?
hi, for QTP TRAINING......SURESH REDDY SMART SOLUTIONS sr.nagar IS BEST OR NOT? how faculty teaches?
In Login two edit box which object class property value is same, How to enter into 2nd edit box in qtp by vbscript.
By default Action1 runs first in QTP. Is it possible to start the run with Action2?