I need to get some data from data base and store this
(retrieved) data in a excel sheet using VB script in QTP9.0
I have created connection for data base
I have created as excels sheet by using
Set XL=CreateObject("Excel.Application")
XLworksheet.cells(1,1).value= rs.fields.item("<<The
data retrieved from data base >>")
I have taken a for loop and changed the cells values (1 as
i and another 1 as j)
But still I am not able to get
Plz kindly tell me know this . It is very urgent
I am running a windows based application.While running the
script on QTP ,The Application pop-up an Error Message
as "object Disabled" in two different scenarios
Scenario 1-->The Application pop-up up a Message for Max
Session Reached(as the application is set to hold 2 session
and if if crosses the pre-defined limit then the error
message pop-up)
Scenario 2-->When Network connectivity is disabled the
Application screen gets greyed out in colour with no
operation possible.
Now through Exception handling features in QTP ,we need to
do the following
For Scenarion 1-->Through Exception handling we need to
just accept the Message pop-up in the Application and and
resume with the call function as is
for Scenario 2--> Through Exception Handling featutes on
QTP we need to shut down the client , restart the client
and resume the call functions as it is
Note: The Application returns an Error Message as "object
disabled" in both the cases i.e for pop-up message and when
the Apllication getting greyed out due to Network failure
how can we enhance the script in such a way that for the
same error message retured by the application in two
different and how to handle them????
Hello Friends ,
I am the new joinner of this website.
I am working with Sapient ,Gurgoan
I would like to ask few qurries regarding the QTP Tool of
(Testing)
Currently working on QTP Tool .
I would like to no learn VB Script can u name some Books
which i get in market.
And a small issue in QTP
I had 2 users right i have to login and send the document
from this user to second user right.
when i am send this doc some contendId number generates
right.
now i am loging into second user and i have to search for
that contentId right i found it now i dont want to accept
the document so i had an opption of check out ok
i have to click on check out
my QTP Code is like this
Browser(" ").Page(" ").WebTable(" ").ChildItem
(3,5,"Image",0).click
Browser(" ").Page(" ").Link("ChecK Out").Click
i new this code is perfectly right but
when i am run the script i have to click on that particular
contentId and click on check out
but now the Problem is started the error is the document
has been already checked out
remeber every time my content id changes means it is the
new contentId which is not been used atleast once
Please help me out in this issue i am in big trouble
How to find the font in qtp.
Scenario:After entering the username and passwd you will be
navigate into the "welcome:Username" page.Now I want to
extarct font for this message.
Hello friends.....
Can any give the methods for Ms-Access, and Mozilla firefox
in Automation Object Model in QTP.
Please give me currect answers...
if you do not understand my question please don't give
answers.
Thanking you.
39
1) How can we use VB script in testing the application?
2) What all are the things(Software application to be installed in PC) we need to
learn VBscript?
95
Hellow friends, I am learning QTP,but here problem is VB
script. please guide me how to learn VB script w.r.t QTP
and if you know any books tell me or if you have any
materials or any use full material or any else w.r.t QTP
please post me
p.p.sekhar
50
How to create pull down menu box using vb script
180
how to write codings in QTP using vb script. please help
me. i am new to QTP. it is easy or very much tough. please
tell me
Have any one know about Test Complete 6, please let me know.
If any one have good material regarding Test Complete 6,
Please send to my mail id:
cns.praveen@gmail.com
40
How to take whole text output from screen of Bitmap
Application.
how to increase the values in text box in a given text box
increament by two values by clicking on button
27
Hello Friends ,
I am the new joinner of this website.
I am working with Sapient ,Gurgoan
I would like to ask few qurries regarding the QTP Tool of
(Testing)
Currently working on QTP Tool .
I would like to no learn VB Script can u name some Books
which i get in market.
And a small issue in QTP
I had 2 users right i have to login and send the document
from this user to second user right.
when i am send this doc some contendId number generates
right.
now i am loging into second user and i have to search for
that contentId right i found it now i dont want to accept
the document so i had an opption of check out ok
i have to click on check out
my QTP Code is like this
Browser(" ").Page(" ").WebTable(" ").ChildItem
(3,5,"Image",0).click
Browser(" ").Page(" ").Link("ChecK Out").Click
i new this code is perfectly right but
when i am run the script i have to click on that particular
contentId and click on check out
but now the Problem is started the error is the document
has been already checked out
remeber every time my content id changes means it is the
new contentId which is not been used atleast once
Please help me out in this issue i am in big trouble
can anybody tell vb script code for alphanumeric and special
character .which is used in qtp the name text field.
30
how to increasing the numbers in a given text box
please write a vb script
40
In the Web page we have a table link, if we click on that
link all the contents under that link will be sorted
(asscending/Descending). Now i want to check in which order
the list is ? for that i need to get the data in to some
var How can i get that cells data?
Hi All,
I am facing one problem in QTP.
There is link object in my application that exist in the
Frame in mozilla firefox. Click event on that object is not
working but once the frame is enabled/activated then click
event works fine.But the frame does not have the activate
property.
This problem is coming in firefox only.
Regards
48
Please let me Know regarding any material regarding VB
Scripting which should be easily understandable for
Beginners.
25
hi all,
i had a question, that how to find out hiding a coloumn in
a table
i had a table having the following column names
NAME DESCRIPTION CREATED TIME CREATED USER
if i right clicked on a NAME column it will displays a
menu having the same column names in a list like
NAME
DESCRIPTION
CREATED TIME
CREATED USER
with check boxes.if i unched any check box, that column
name should not be appear in the main table column names
could anyone please solve this problem?
can anyone tell me the procedure of interview held in
applabs
111
If anyone knows abt Test Complete material,
Pls let me Know.
if u have any material or any documents.....
Pls mail me on this mail Id......
This is very Urgent Requirment..... for my Project.....
53
How to identify column in VSFlexgrid? My VSFlexgrid window
is identified as 'Active X Control'
Site Map
