How to get the column count and column name from the
resultset in the database connection program?
Answer Posted / punit
in ur mysql database there is 1 database with name
information_schema,
so 1st type,
use information_schema;
inthis data base there is 1 table COLUMNS which contain all
the info related to allthe tables in ur mysql,
so hit the following queri for youe column count:-
select count(*) from COLUMNS where TABLE_NAME='Table name';
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
suppose in the middle of the project QTP will not work properly, then what do u do? and ur team?
Explain building blocks of the bpt framework ?
What is the expert view?
I need to obtain the parent of an object programatically, so if I have: winButton("aButton") I need to obtain the parent part: window("Window1").Dialog("Dialog1") so I can programatically create a string of the full name of the object to call it with an execute statement in QTP I would like to use something like: part[1] = "window(""Window1"")" part[2] = "dialog(""Dialog1"")" so I can do: exeLine = part[1]&"."&part[2]&"."&"winButton(""aButton"")" Execute exeLine Apart from keeping a record of the window/dialog hierarchy is there a parent or path function/ command Thanks Adrian
How to integrate QTP with QC using VB Scripting? What are the prerequisites to connect with QC?
In qtp, explain what is qrs file?
when will you do debug your script? and explain that process?
What do you mean by checkpoints in qtp?
What is the extension of QTP local Repository? If it is .mtr then what is .bdb extension stands for?
Whats the realtime QTP testing process
Can any one brief some detail on how the shared and action object repository utilized/implemented in a real time project. I already know how to make shared object repositor by saving OR as .tsr extension..I wanted the actual concept of implementation...couple of live examples will be highly appreciated. Thanks
UFT 12.02 which ALM version will support
What is the use of Debug Viewer?
what is the difference betn QTP 8.0 AND PREVIOUS VERSION
I am a newbie to QTP / Automation testing. I want to develop a script that creates a data file automatically with proper headings using VBScript in QTP.