Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


There r 1000 rows and 1000 coloums , in that I want pickup a
name of the coloumn , pls dont say in sql statements , in
interview one of the interviewer said it was a wrong answer
pls any send me answer its urgent



There r 1000 rows and 1000 coloums , in that I want pickup a name of the coloumn , pls dont say in..

Answer / ashok kumar

src = "DRIVER=SQL Server;SERVER=<ur
server>;UID=<username>;PWD=<password>;DATABASE=<database>"
Set dbconn = CreateObject("ADODB.Connection")
dbconn.Open src
Set dbrecset = dbconn.Execute(query to connect table)
For i = 0 to dbrecset.Fields.Count-1 'to get total col. count

Print dbrecset.Fields(i).Name 'to print col. name

Next

Is This Answer Correct ?    1 Yes 3 No

Post New Answer

More QTP Interview Questions

Difference between image checkpoint and bitmap checkpoint

2 Answers  


What is the use of Accessibility check point?

3 Answers  


What is CMMP and CMMH?

0 Answers  


Give me exact application where we should use low level recording?

6 Answers   CTS,


how can u find the syntax errors or other script errors in your test during the execution of your QTP Test - (i.e., not after the execution/test run finished, but before finishing the test run)

2 Answers   HCL,


how to make connection to a remote mysql database in qtp any one can please provid eme deatail steps.

1 Answers  


What is the difference between a Test and a Business Component? Is it necessary to use Business Component while testing an application in the real time?

2 Answers  


Dim ExcelSheet Set ExcelSheet = CreateObject("Excel.Application") excelsheet.application.visible = true ExcelSheet.ActiveSheet.Cells(1,1).Value = "This is column A, row 1" ' Save the sheet. ExcelSheet.SaveAs "C:\DOCS\TEST.XLS" ' Close Excel with the Quit method on the Application object. ExcelSheet.Application.Quit after run this script i am getting error"The test cannot continue due to unrecoverable error"

3 Answers  


How to record object in runtime. I am testing one Image website in which every time image change on home page.so if i records the image list but during running image get change, and QTP gives error

1 Answers  


What is the difference between gettoproperty and settoproperty?Explain with an example?

4 Answers   QQS, Satyam,


Hi frnds, does anybody know if there is anything called "thin point" or something in qtp? thanks in advance.

0 Answers   ABC, scintel,


Is QTP supports Unix. If yes, then how the test automation is done?

0 Answers   iFlex,


Categories