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
- 15945 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 can i use text check point in descriptive programming. or else is there any way to compare the text in the application and the text in data table.
I would like to do some certifications in QTP. please suggese what kind of certifications can i do. I am currently put up at chennai. So please suggest some reputed centres where these courses are offered.
How to perform cross platform testing and cross browser testing using qtp? Can you explain giving some example?
Hi, Is there any function or vbscript in QTP to clear the cookies,sessions. Please help me in this.
Thanks....But can u tell me how i use the QTP for GIS with one Example...
can we change the name of a check point? when will you start writing testcases? do you follow any methodology for writing test scripts? qtp is key word driven testing or data driven testing?
What is a recovery scenario?
How we can capture the dynamic object ex:(rotating globe) in the web page with time gaph is 5 sec..
how much space occupies in object respository by default?
1)how to write test cases in test director? not go throuth requirments and plan but should be different way i need? 2)what is the mediator between qtp and application or project?
After the execution of a script how do u upload the results to Quality Center. Pls anyone explain in detail. It is very urgent._______Thanks a lot!!
If I change the object name in one action will it be updated in all the actions? Or not?
WinRunner 
