Interested to Buy Any Domain ? << Click Here >> for more details...
write a VBscript code to parametrize test script using test
data from sqlserver database?
- 2 Answers
- 15914 Views
- IBM, Polaris, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kamesh n
first connect to database using the following script
set sqlconnection=createobject("ADODB.connection")
set sqlrecordset=createobject("ADODB.recordset")
To open the connection
sqlconnection.open "You have to mention your database
connection string"
sqlrecordset.open "Give your query",sqlconnection
to run through all the records
if not sqlrecordset.EOF then
suppose your are going to set it to a textbox then
Browser(browsername).page(pagetitle).webedit
(testboxname).set sqlrecordset(columnname)
end if
| Is This Answer Correct ? | 8 Yes | 1 No |
Answer / rajh
dim con,rec
set con=create object("adodb.connection")
set rec=create object("adodb.recordset")
con.open"provider=sqloledb.1;server=name;username=scott;pwd=tiger;database=dbname'
rec.open"sql statement"con
while not rec.eof
window("winmame").winedit("uname").set rs.fields(un)
in the same way use the data
loop
| Is This Answer Correct ? | 6 Yes | 0 No |
How to test login module with different username and password by using data driven testing in QTP?
The structure of keyword driven frame work is like a folder structure the different sub folder are 1-functional libray folder 2-object repository folder 3- database folder 4-appliction1.xls 5-initalzation vbs file 6-sequence file 7-driver script 8-test case list file My question is whether these are in a local server machine or in our pc.((whether It like Vss). can u give example of driver script(code)
Give me exact application where we should use low level recording?
How many actions we can write in a test?
What is the difference Between LowLevel and Normal Recording Modes?
In descriptive programming how we know the properties of the objects, if application is not developed and the prototype of the application is also not developed.
How does qtp identify the object in the application?
How to interact tool & application build in QTP?
How to map the test cases to requirements in QC?
How to handle run time errors?
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
What is creation time property and how does it work?
WinRunner 
