How to get the column count and column name from the
resultset in the database connection program?

Answer Posted / tvsrkc

we can get the column count by following code
------------------------------------------------
set colcoll=rs.fields
colcnt=colcoll.count
for i=0 to colcnt-1
msgbox rs.fields(i).name
rs.movenext
next

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

when a test case is written how u test using qtp

1661


i have doubt suppose iam purly working in manual, when i will get work to do on sql and performence testing? pls any one clarify doubt?

1568


How can you exit from an action?

619


hi frinds i need help .i have 4 + yrs exp in testing and nearly 2 yrs exp in QTP and QC .currently iam working north fast 2 yrs iam looking for job in south is there any openings plz letme know my mail id is pbre1980@gmail.com

1578


How do you create regression test packs?

616






If you are testing a web application then what will you test in that application?

1549


How do I get the QTP scripts result in xml format by using vb script function?

1791


When to use shared and local object repository?

646


Explain the difference between data driven testing and parameterization ?

594


Explain more about the Test Fusion Report of QTP?

608


Hi,Sudhanandareddy plz forword framework and ppts for QTP to me. This is my mail id: ranjith_99reddy@yahoo.co.in (your contact number also)

1746


Explain quicktest professional (qtp) testing process?

541


1.How do u prepare the test suits in QC? 2.How do u convert requirements to test plan in QC?

1503


can anyone tell me what to say in interview when interviewer asks about "tell me about your framework in your project"?

1411


Can anyone tell me how i used QTP 9.2 use for GIS based S/w with an example?

1693