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.

Answer Posted / cheryl

I think you need to set your for loop so that it reads only
2 records or as many records from the record set that you
want. i.e for i = 1 to 2

read the next record
next

this way you have the 2nd record

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to modify object property in qtp ?

772


With what extension you can save the list of tests in a file to run in test batch runner?

774


if anyone has idea of the interview procedure in covansys, plz send me a mail?

1733


how to disable the pop ups through QTP using a script

1957


What are the different attribute used with regular expression?

723


what is meant by function library?Public and private functions in function library? if private functions are applicable for only for the particular test means then y we have to add those to function library?

1682


give me the code to save all messages of inbox of gmail into a folder and notepad

1829


Explain the difference between call to action and copy action?

730


how to test Web application using QTP software

1763


How many types of trigger events are there in qtp?

761


What is the file extension of the code file and object repository file in QTP?

853


Where can I find and view run-time data table?

731


How can i test an application like Google Earth.In my application data will be fetched from a oracle database based upon which graphs are generated..so these all are dynamic..how can i use qtp here..alongwith that how can i test the map generated by a satellite just like google earth..

1951


Define Environment Variable in UFT and its uses?

806


What are the different kinds of test steps?

804