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

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

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.

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.

Answer / chandana

Dear Ashok u told the processor ? can u explain me in detail
with steps Plz (chandana)

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

Answer / lotr

Good reply Sunil. I guess they must have replied if that
solution worked or not !!

Maximum synchronizing time out in QTP

3 Answers   Kanbay,

difference Between Call Run action and copy of action?

1 Answers  

What is Data driven Testing Frame work.Anybody can expain it in Detail.. Pls anybody can give the answer.. Thanks in advance...

1 Answers   Navis,

give me the code to save all messages of inbox of gmail into a folder and notepad

0 Answers   Infosys,

Hi my name is mohan. I am working as a manual tester.. And now i want learn QTP.. is there any online websites to learn QTP for free if u know any plz help me out..,.or send mail to k.mohann.mohan@gmail.com

3 Answers   Wipro,

What type of VB script u had done in expert view?

1 Answers   HCL,

Is it possible to test Flat file using QTP? I have two file- first file is Input file and second file is output file. Input file has Format like first 2 field is record type, next 10 field is Description. Output file also has format. I want to check this file format using QTP. Is it possible?? please reply with example.

2 Answers   Wipro,

Hi, Has anybody attended IBM interview on 17th APR 2010,and got offer letter? I had given interview and selected also but still did not recieve offer letter.

5 Answers   IBM,

I've some problem in Descriptive programming plz help me. I've written in a click event code in Functional library when I run this flight reservation program It is not run. How to I write multiple click event in functional library. My program is this. I have associate an action with functional library. Public Function ClickButton(byval ApplicationName, byval WindowName, byval ObjectName, byref Comments) If Dialog("text:=" &WindowName).WinButton("text:=" &ObjectName).Exist Then Dialog("text:=" &WindowName).Activate Dialog("text:=" &WindowName).WinButton("text:=" &ObjectName).Click Elseif Window("text:="&ApplicationName).WinButton("text:=" &ObjectName).Exist Then Window("text:=" &ApplicationName).Activate Window("text:=" &ApplicationName).WinButton("text:=" &ObjectName).Click End if End Function

2 Answers   Amdocs,

Explain script generated at the time of setting runtime property?

1 Answers  

how to write this script using descriptive programming? the script below is the script generated by QTP plz write the script using descriptive programming? plzzzzzzzz do answer thanku Browser("Welcome: Mercury Tours").Page("orkut - login").WebEdit("Email").Set "test123" Browser("Welcome: Mercury Tours").Page("orkut - login").WebEdit ("Passwd").SetSecure "475259b450e3d212bef4a5f5ce9d32ebcbf4" Browser("Welcome: Mercury Tours").Page("orkut - login").WebButton("Sign in").Click Browser("Welcome: Mercury Tours").Page("orkut - home").Link ("Logout").Click Browser("Welcome: Mercury Tours").Page("orkut - login").Sync Browser("Welcome: Mercury Tours").Close

3 Answers  

what is defenetion of kiran can u tell me plz CVS, SVN

0 Answers