Interested to Buy Any Domain ? << Click Here >> for more details...
in a database table there are 3 columns (name ,
marks,grade) , in application after retrieving data from
db to fields name, marks click ok button then grade should
displayed ---for this how to write vb script prgm
- 3 Answers
- 10291 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Let us assume that application is VB application
You can copy and paste in ur PC then analyze u will
understand easily
E.g:
RC=datatable.GetRowCount
msgbox RC
For i= 1 to RC
vbwindow("Form1").vbedit("name").Set DataTable("Name",
dtGlobalSheet)
vbwindow("Form1").vbedit("marks").Set
DataTable("Marks",dtGlobalSheet)
vbwindow("Form1").vbbutton("OK").Click
' Here it will retrieve grade and displays in msgbox
grade=vbwindow("Form1").vbedit("Grade").GetROProperty("text")
msgbox grade
' It places Grade in Run Time Data Table
VbWindow("Form1").VbEdit("Grade").Output CheckPoint("Grade")
' Now we can export that data in to our desired location
Next
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / kk
I feel, I could not understand your question.
I am not sure this syntax is correct, better to check it.
i=Browser().Page().WebTable().RowCount()
For x=1 to i
myData = Browser.page.WebTable().GetCellData(x,2)
'Assume, 2 is the number of Name Column.
allData=myData
'Use different Logic
Next
You can get all the data in those 3 columns.
The last part in your question is not understandable for me.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / kk
allData should be declared Globally, outside of any
Loop/Condition.
allData=myData
I am sorry, correction for the above line.
allData=allData & vbcrlf & allData
I would like to know people feed back, about this posting.
| Is This Answer Correct ? | 0 Yes | 0 No |
Can we run multiple QTP scripts one after the other without manual intervention? How?
what is the difference between an Action and a function in real time
How Does Run time data (Parameterization) is handled in QTP?
I have faced one issues while doing test in QTP. I have described the scenario below. 1. I have to test web application.In that i want to give input of drop down values in the application. 2. Suppose Drop down has 5 value "A,B,C,D,E".I would like to give value from data table of QTP. 3. I have changed the drop down value as variable in Keyword view and given values in data table "A,B,C,D,E" as one below one. 4. While i am running the script it could not identify the drop down value which is in Data Table.It shows message. How to make value identify by QTP?
how to use command prompt using qtp?
Hi All, I want to know how can we schedule QTP scripts. Am using 9.5 version and in our office they want to schedule individual scripts of QTP so that it can run unattended during night time, Please help me how to do that. 2. what is the use of silent test run in qtp can I schedule the scripts in Silent runner, Please explain. 3.I retrieved data from the database using output value -> Database output value. the result of the query for eg is 5 rows, iam able to output the first row by selecting the cols and adding it to output, but am not able to do it for the rest of the rows. please tell me how to do it. Sorry for posting so many qns, am not able to find answ to any of the above in any websites, hoping that someone would really help me with these here, please help me. awaiting for ur immediate revert. Priya
How to find local host name using QTP?
How to open an application through scripting?
Can we do server automation by QTP? If you have any helpful links ,pls post it. Thanks Uma
How to convert manual test cases to automated testcases
What is the difference between low level recording and virtual object.
what is exact difference between smoke and sanity testing?
WinRunner 
