How to get the column count and column name from the
resultset in the database connection program?
Answers were Sorted based on User's Feedback
Answer / ram
you use following sql query
select column name, count(column name)from table name.
| Is This Answer Correct ? | 3 Yes | 3 No |
Answer / 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 |
Answer / mahesh
select count(column name) column name from the table.
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / nageshbijoor@gmail.com
you can get column count using following code
totalrec = 0
DataTable datatable
datatable = ds.Tables["tablename"]
totalrec = datatable.Rows.Count
Label1.Text = datatable.Rows[currrec]["columnname"].ToString
()
| Is This Answer Correct ? | 3 Yes | 4 No |
Answer / krishnat.qa
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 ? | 1 Yes | 3 No |
Which method do you use to retrieve data from the WebList object?
wat are views in qtp explain
We have an application which generates links( more than thousand) based on the time stamp dynmically.Each link will download an xls file. we are supposed to click a particular link (which link to click will be obtained thru some buisiness logic).Now the issue is QTP is not recogniging the link(say Var1) though its properties showed mandatory fields text=xyz and html tag=A.I used following code to do this. Browser("ABC").Page("123").Link("text:=" &Var1,"html tag:=A").click, can any one suggest why this is not recognised by QTP though syntax is correct?(Is there any sync issue to be considered?Because on clicking the link it will take 5 mins to open that file)
hi. I Am working in Small IT company as Test Engineer. But am looking for change. I have 2+yrs experience, but my problem is MCA 72%, remaining all are Second Division. plz give solution for my problem.am elgible for MNC's or not. if not plz give suggestion............ already i forwarded my resume to lot of MNC's but. I didn,t get CAL............ plz give any suggestion.
Can I do Game testing with QTP tool
images are dynamically changes how to compare two images
How to record & run on Japanese language application using english version of QTP ???
If we are record a same web page for 2 times.1st time it is showing 6 objects in the Object Repository and for the 2nd time it is showing like 7 Objects in the Object Repository why it is happening
in real time when we are creating the script by default it is going to save in action object repository or not any way my question is in one of my interviewer said that in real time the default object repository is action object repository and by using quick test plus they are going to merge is it correct i said that by selecting the object repository as shared one in selecting the test>>settings>>resources but she is not convinced what is the correct one
write a qtp script to see time in windows command prompt? its urgent....
how to capture tool tip in QTP and which check point is needed
How we can merge the object repositories?say if we have 2 or 3 object repositories then how we can merge them?Is there any option in QTP to merge the object repositories?