Interested to Buy Any Domain ? << Click Here >> for more details...
how we do database testing with qtp using descriptive
programming?
- 22 Answers
- 39054 Views
- Nutrins, Rohit Technologies, Symphony, Syntel, TCS, I also Faced
- E-Mail Answers
Answer Posted / harikrishna
Database testing is all about data validation & data integration.The correctness of new data insertion is called data validation.
The correctness of changes incurred due to insertion of new data from parent table to child tables is called data integrity
All we have to know is DML(select,insert,update,delete) commands in sql to use to dbase testing
ADODB-we use this to connect to any kind of dbase(sql,oracle..etc)
rso(Record set object)-a temp buffer where we use to store for retriving information frm dbase.
here am posting an example hw to connect a dbase and count no.of rows in a table via qtp
Option explicit
Dim cono,rso,n
Set cono=createobject("ADODB.connection")
cono.Open("DSN=hari")
Set rso=createobject("ADODB.recordset")
rso.Open "select * from harikrishnaa",cono
n=0
While rso.EOF<>true
n=n+1
rso.MoveNext
Wend
print "no of rows in record set is"&n
Set rso=nothing
Set cono=nothing
..................i used my own crated DSN.instead you shud use connection strings(which are ready available in google search engine)
HAPPY TESTING ALL.plz write comments as i hav used my time 4 u
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain how Selenium is different from UFT?
what is Property......End Property loop? how to write sript for it in QTP
How to run a test using quicktest professional?
What is TOM in QTP?
How you can decide which type of object repository you have to use?
What is the extension of the qtp local repository?
What is system testing and what are the different types of tests you perform in system testing?
How to replay a script in qtp?
How many add-ins comes by default with qtp?
What is optional step in qtp? How you can add optional step in qtp?
What is the significance of “action 0” in qtp?
How did you use regular expressions in QTP and also in WR?
How to test the login page in different ways in automation testing and i need code?
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 r the different filters in defect in quality center
