write a VBscript code to parametrize test script using test
data from sqlserver database?
Answer Posted / 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 |
Post New Answer View All Answers
What are the different types of checkpoints?
what is the advantages and disadvantages of using functions instead of re usable actions
Hi, I got error message as "object does not support this property or method: "Test.Actions" when i execute the following line of script on QTP 9.0 Dim qtApp, qtRep Set qtApp = CreateObject("QuickTest.Application") Set qtRep = qtApp.Test.Actions("Action1").ObjectRepositories Can anyone tell me where i am wrong.
What are the ordinal identifiers in web page?
Is it possible to refer the same object for referring more than one object that are of different class using the descriptive programming approach? Suppose my code is 'To create the object named as obj Set obj=Description.Create() 'To define the values obj("title").value="IE" obj("type").value="text" obj("html tag").value="INPUT" 'To set the value Browser("IE").Page("Yahoo").WebEdit(obj).Set "xyz" Can I refer the "obj" object for the three objects like Browser,page and webedit objects? If so how?
What is the syntax to call one action in another?
What is quicktest professional?
Can we create a qtp test from qc?
1.Qtp suppots Unix& linx or not 2why qtp suppots shell script.
Can QTP be used for GUI testing ?, We are using Java with MySQL and Operating system is Linux. We are NOT using the web.
What are parameterizing tests?
regular expression in qtp standar check point for months from accepting months from january to december only
How to add object to object repository in qtp9.0 Suppose for brower yahoo home page
how could i download qtp in which i get add-in support for 'oracle' is there any way to get it? i finding but not getting pls help me out :)
What is the descriptive programming?