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
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 |
When and why do you use "OPTION EXPLICIT" in VB Script. Is there any online help or something to learn the script for Beginners?
write progamming connecting QTP to database sql? this is question asked by interview? pls any answer this?
Can you write User defined function for WebEdit ? Note1: This function can be used for all web edits in all pages Note2: Don't use Child objects method
I m new to QTP? Is it necessary to know VB for learning QTP for Automation? Can I understand QTP excellently Without practical automation?
Can I import a excel sheet in Action1 datatable? How?
How is the Bitmap checkpoint different from Image checkpoint?
what is virtual object?
I heard that in Hyderabad Ameerpet is renowned for its training institutes it has , but from my own experience I can only say that this institutes have become money making machines losing their cognitive ability and ethics , can anybody tell me is there a good ins. in hyderabad for testing tools.?
Explain the benefits of quick test pro(qtp)?
What is the use of Regular expression?
what happen in object repository(shared)if we call an existing action from an external action ? and what happen in object repository(peraction)if we call an existing action from an external action ?
Can anybody let me know how to test the Drag and drop feature of the column in a .net application...eg..i hav to test the drag and drog feature of a table(swftable) in a application..plze help!!