There is a table with 4 columns and 10 rows, how to write the
script to display the first column records using qtp? can
anybody help me with script?
Answers were Sorted based on User's Feedback
Answer / kishan
rcnt=Browser().Page().webTable().rowcount
ccnt=Browser().Page().webTable().columncount(2)
for i=1 to rcnt
print Browser().page().webtable().getcellData(i,1)
next
(or)
for i=1 to rcnt
set obj=Browser().page().webtable().childItem
(i,1,"webElement",0)
print obj.getROproperty("text")
next
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / saharsh
clumn name: Name,Studies,rank,status
namColumnname=B("),P("").webtable("").Getcelldata(1,1)
studies=B(").P("").webtable("").getcelldata(1,2)
rank=B(").P("").webtable("").getcelldata(1,3)
status=B(").P("").webtable("").getcelldata(1,4
)
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / gnani
Hi Prasanna,
It is a webtable.
Even I want the script for both webtable and datatable.
Can any help me by sending the script?
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / manas
Dim Conn, rs, ListOfRecords, x
' Connect to the Microsoft Access Database by createing a
object
set conn=CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "c:/DataBase1.mdb" ' ex: Name of DataBase is
DataBase1.mdb
' Retriving data from Access using the SQL Query
' Column_name1 - Suppose first column
' Table - Suppose Name of Table
set rs=CreateObject("ADODB.recordset")
rs.Open "Select Column_name1 from Table", conn
for each x in rs.Fields
ListOfRecords = ListOfRecords & x.Column_Name1 & vbCrLf
next
MsgBox ListOfRecords
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / tvs ramakrishna chowdary
Set con=createobject("adodb.connection")
Set rs=createobject("adodb.recordset")
con.provider="microsoft.jet.oledb.4.0"
Con.open"d:\db1.mdb"
rs.open "select * from cal",con
Do while not rs.EOF
msgbox rs.fields(0)'o is first column
or
msgbox rs.fields("column1_name")
rs.movenext
Loop
| Is This Answer Correct ? | 0 Yes | 0 No |
what is the difference between wait and wait function
does qtp need record and playback in realtime. plz tell exactly wat happens
Suppose u run ur script today and it is working fine ,nobody has changed the setting and all.u r the owner for the script. But when tomorrow I ran the same script again it got failed and It didn't able to identify one object. Can you tell me what would be the reason for this
Explain how you can delete excel file in qtp?
1. How can we use same object repository and Testscript which is in English flavor to check the application in different languages thru QTP?(Chinese,Dutch,French) - I generated script in english and want to use the same script with different languages? - for windows i used regular expressions - I need for edit box,button and combobox, (English,French,Dutch,Chinese) These are the properties of a button in different languages Properties English Dutuch Chinese French x 400 758 631 601 y 673 603 592 676 windowstyle 1342242816 1342242816 1342242816 1.34E+09 windowid 2 2 2 2 windowextended style 4 4 4 4 width 120 120 120 120 visible TRUE TRUE TRUE TRUE righttoleft reading FALSE FALSE FALSE FALSE righttoleftlayout FALSE FALSE FALSE FALSE rightaligned FALSE FALSE FALSE FALSE regexpwndtitle cancel Loschen Chinese language Annuler regexpwndclass button button button button objectclass button button button button hwnd 132872 657228 656932 656782 height 33 33 33 33 focused FALSE FALSE FALSE FALSE enabled TRUE TRUE TRUE TRUE attached text abs_y 669 599 627 597 abs_x 396 754 588 672 text cancel Loschen Chinese language Annuler nativeclass button Button ordinal Identifier type,Value none none none none smartidentification FALSE FALSE FALSE FALSE comment
suppose u have two send buttons(same width,height,font) on an application write a descriptive programming
Difference between test object and run time object?
In an(AUT) web application their are two frames as fraMain and fraFooter. Both the frames contain link which needs to be retrieved at a single step. I tried it using "Regular Expression" as fra.* but QTP doesn't recognize the object. So Plz help me out to get resolve the problem:-)
Reverse string without mid or streverse function.
how to create flat file datasubmission in qtp
What Folder Structure following in Keyword Driven Frame work?
please any one can explain the keyword driven framework. with gmail example.