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

They asked by using qtp recording writing scripting

2071


I am trying to install QTP 9.5 but i am getting error message saying that ("Path is \QuickTest Professional\bin\vb_init.exe") vb_init.exe file is not find. can anybody give me the advise what to do ?

1767


Which features or drawbacks of QTP lead to the upgrade for a newer version?

575


if there is a web table of having row and colmns.a button is placed at 2nd row's 3rd column which is worked for both edit and delete..how to write script for the button to test both operation on the web table using desriptive programing.. plz help me on script wheather using getroproperty Q2)what is the command for taking valiue from a web table in qtp

23933


Differences between text and test area checkpoints?

585






Explain the concept of object repository & how qtp recognizes objects?

572


Call to copy of an action and call to existing action… i know the diff but in real project how to use..? i want live scenario.pls help me..

1283


In application which areas to be automated and what kind of situation will be take? using QTP? Plz give me the clear answer

1943


How many add-ins comes by default with quicktest professional (qtp)?

561


What does it mean when a check point is in red color? What do you do?

568


Explain the parameter in qtp?

581


What are the different types of checkpoints?

588


Describe how Smart Identification is used

1700


Explain how Selenium is different from UFT?

693


How to delete an object from the object repository?

595