Interested to Buy Any Domain ? << Click Here >> for more details...
how do u retrieve data from a database ? i.e. i want to
retrieve 2nd record only from a database ? write code for
this. by using ADODB connecton, RSOBJ and using a FOR loop
we can retrieve all the records( ex: if we give query as
select * from emp). but i want only 2nd record. so how to
acheive this.
- 2 Answers
- 8477 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / praveen
set dbobj=createobject("adodb.connection")
dbobj.provider="Microsoft.jet.oledb.4.0"
dbobj.open "<path of .mdb(msaccess)file>"
set rsobj=createobject("adodb.recordset")
QRY=select * from emp" 'for example
rsobj.open QRY,dbobj
for i=1 to 2
rec=rsobj.getrows(3,0) 'retrieve 3 records starting from 0
rec1=rec(0,i)
next
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
In Remote acess server how u run a test?
What is the extension of qtp local repository?
Did the scripts need lot of maintenance? If yes, why?
What is qtpro?
To which environments does quicktest professional (qtp) supports?
What is a recovery scenario?
What is the extension of QTP local Repository? If it is .mtr then what is .bdb extension stands for?
What is the parameterization? Give one example?
Hi frnds, does anybody know if there is anything called "thin point" or something in qtp? thanks in advance.
How can I find out the cursor position through QTP suppose I am keep tabbing(Pressing the tab key continuously) and stoped at a position Now I want to find out where the cursor position is
How do you synchronization point through DP?
What is QTP’s model for test creation?
Hi, How Accessibility checkpoint in QTP can be implemented in the test script?
suppose in the middle of the project QTP will not work properly, then what do u do? and ur team?
What is qtpro? What is quick test pro?
