Answer / akothuru

VB Script Code to retrieve all column names

var_ConnectionString = "" 'specify the connection string
Set objConnection = CreateObject("ADODB.Connection")
objConnection.Open var_ConnectionString
Set objRecordSet = CreateObject("ADODB.RecordSet")
strSqlQuery = "select * from employee"
'Execute query and Store the results into Record set
objRecordSet.Open strSqlQuery, objConnection
For var_Loop = 0 To objRecordSet.Fields.Count - 1
colname = objRecordSet.Fields(var_Loop).Name 'column name
msgbox colname
Next

Is manual Testing replacement of automation testing?Which types of testing we can not do in automation testing but can do in manual testing?

1 Answers   Hewitt, Wipro,

---

can any one tell me how to select some text.i need the script for that

1 Answers  

---

Inserting a Call to Action is not Importing all columns in Datatable of globalsheet. Why?

4 Answers   Accenture,

---

HI All i need one suggestion.is there any companies taking corresponding degree courses. i have 3+ yrs exp in QTP and i am working north side. iam looking for job in south.

1 Answers  

---

In qtp, explain what is qrs file?

0 Answers  

---

Please any on explain usage of "on error resume next","On error goto 0" with sample code....Thankyou......... when a tester is asked to execute 100 scripts in a short time..(the server will be down in another 10 min)..how he has to run those scripts?

2 Answers   Datamatics,

---

regular expression

2 Answers   Wipro,

---

in Qtp,how to display user name and pwd (script)in data table(global sheet).

2 Answers  

---

How software automation specialist enter steps in the Expert View?

0 Answers  

---

request to add whatsapp grp for test engineer

1 Answers  

---

what is the difference between the modular framework and datadriven frame work

2 Answers  

---

suppose 3 excel sheets are there * we are trying to check for login credentials for a page. userid from excel1 , password is from excel2 whether the page is opened or not that checkpoint is result is should be stored in excel 3.... this qus i have faced in IBM technical round... please tell script for above query

1 Answers   IBM,

---