How to get the column count and column name from the resultset in the da

Advertise your Business Here

Refer this Site

Login | Sign Up


	SiteMap shows list of All Categories in this site.

Categories >> Software >> Testing >> Automation Testing >> QTP

WinRunner Interview Questions

Load Runner Interview Questions

QTP Interview Questions

Test Director Interview Questions

Rational TestSuite Interview Questions

Silk Test Interview Questions

Automation Testing AllOther Interview Questions

Question

How to get the column count and column name from the

resultset in the database connection program?

Question Submitted By :: Sreeprasad

I also faced this Question!!

Rank

Answer Posted By

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

Answer
# 1

you use following sql query

select column name, count(column name)from table name.

Is This Answer Correct ?

3 Yes

1 No

Sreeprasad

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

Answer
# 2

in the vb script we use genralluy to count the rows as 
rowcount=datatabble.GetSheet("Sheet name").GetRowCount
MsgBox(rowcount)
i fyou need sheet count
datatable.getcheetcount
Thank you

Is This Answer Correct ?

0 Yes

1 No

Akshara

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

Answer
# 3

Thanq Akshara..

Is This Answer Correct ?

0 Yes

1 No

Sreeprasad

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

Answer
# 4

Hello friends, just observe the question.

It is not Datatable, it is database connection program.

Say i user "select * from table"

Here i dont know how many col r there in my table.

So give the answer to find the number of columns in that 
table.

Is This Answer Correct ?

0 Yes

0 No

Uday Kumar_anem

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

Answer
# 5

Select column_name, count(column_name) from user_tab_columns
where table_name='EMP' group by rollup(column_name);

Is This Answer Correct ?

0 Yes

0 No

Prasad

Question	Asked @	Answers
Other QTP Interview Questions


Few basic questions on commonly used Excel VBA functions.		1
how we can know qtp has used smart identification machanism during the execution.	IBM	2
WHAT IS THE FRAMEWORK & ARCHITECTURE OF YOUR PROJECT	Wipro	2
Can we add the objects of an application dynamically?	KEN-Group	2
I am not finding pages and links in object spy on web testing. I am only getting window and winobject. where is the problem? thanks		2
What is the real use of different actions in QTP		1
What are the most frequent errors you faced while executing your scripts?		1
How to create a run time propertyfor an object?	IBM	3
can u Give Procedure to Handle Pop Window & write Code for that	CTS	1
You have an application version 1 with 5 combo boxes, Developers develop version 2. Here they replaced bottom 3 combo boxes with each other. While executing the Test script for version1 no errors. When we execute the Test script for version2 that QTP showing the error message "Object not identified" remember no property changed in version 2, ordinal identifier also disabled. Find what properties might change here in this scenario	ADP	4
how can we write descriptive programming for menus when qtp is not able to identify it..and how can we write descriptive programming for partially identified and non standard objects..do i have to map the objects before writing the script		1
1. In build1 there is a page with two check boxes and a submit button. You have prepared a script for that page and its working fine. In Build 2 the developers have added two checkboxes in the page. Will the script prepared for Build 1 work for Build 2 or not. If yes, why and if No, why. Remember the developers have not touched the object properties of the textboxes in the page.	ADP	2
What is API?		1
What are the problems / difficulties faced when you used Smart Identification ?	Keane-India-Ltd	1
How do u retrieve data from a text file into different variables. i.e. in a text file named "source" , the data is like : india,1000,japan,200,china,50,singapore,45050 this is given in the first line of the text file. in the second line of the text file the dta is: sun,moon,planet,river,earth,water if u use "readline" method by using FSO concept u can retrieve the entire line in to a variable. but i want to import each field (ex: "india" in one variable, "1000" in another variable etc..). Apprecitae proper replies.	Semantic-Space	4
can objects recogonised without repository?	AZTEC	8
hi i have one doubt i have 4 yrs exp in testing and iam working one mnc in north but i have completed my degree correspodene is the companies are accept in south side some people are tellig they won't agree but i need correct answer plz let me know which companies are taking and not taking thanks in advance		8
I install .Net Add-Ins in my system. It installed properly. But all the objects are recognizing as window objects only. But it has to recognize as swf objects. In Record and Run setting i selected 'Record and run test on any open browser' and Record and run test on any open Windows-based application' Can any one tell what setting i have to do to recognize objects correctly as swf...? Please give some suggestions..?		1
. Types of properties that Quick Test learns while recording?		1
Hi,How to write regular expression for inbox(10) {here 10 is changing while playback}.tell me the pettern.		4

For more QTP Interview Questions Click Here


Copyright Policy \| Terms of Service \| Help \| Site Map 1 \| Articles \| Site Map \| Site Map \| Contact Us \|

Copyright © 2007 ALLInterview.com. All Rights Reserved.

ALLInterview.com :: Forum9.com :: KalAajKal.com