Answer / snig

http://funandknowledge.blogspot.com/2008/03/qt.html

Answer / gms

'Declaration for SQL
Dim objConnection,objRecordset,count1

'Connecting to the database
Set objConnection = CreateObject("ADODB.Connection")

objConnection.Open "Driver={SQL Server};" & "Server=YOUR
SQL SERVER NAME;" & "Database= DB NAME;" & "UID=USERID;"
& "PWD=DB PASSWORD;"

'Running the query
sql1 = "GIVE UR QUERY HERE"
'Create record set for the query
Set objRecordset = CreateObject("ADODB.Recordset")
objRecordset.Open sql1, objConnection

As this is a Back-End process, you cannot view the result
set. so you can place the result in the datatable using the
following steps:


'Retrieving data from the database to the data table
count1 =1
While Not objRecordset.EOF
datatable.SetcurrentRow (count1)
Datatable("C",1)= objRecordset("nbr").value
objRecordset.movenext
count1 = count1+1
wend

How do you handle multiple banners(at the top the page, the banner is scrolling) in a web page(Dont take the name property(regular expression))

0 Answers   CFC, iton,

---

What is the syntax for how to call one script from another?

0 Answers  

---

we have 5 default properties we want add more Default property in Object Repository how to add the property

2 Answers   Nous,

---

Hi iam shankar here, right now iam working on manual testing. i want to switch over automation tool qtp, right now iam taking training class outside on qtp, please let me know the cost of QTP tool for full version, wether it's an annual subscription or monthly subscription.

0 Answers  

---

How can we disable smart identification at the time of recording? Ideally, smart identification should be enabled only at the run-time.

3 Answers  

---

How to handle Run-time errors?

1 Answers   Crea,

---

Hi experts. I want to create a framework for the Flight Reservation sample application.Can anybody tell me the files and the contents , and how to create them.Thanks

2 Answers   IBM,

---

what is mean by output parameters? I need full description with example. tell me any one please

1 Answers  

---

request to add whatsapp grp for test engineer

1 Answers  

---

How do you return a value for an array.

1 Answers  

---

Whenever i'm running 3 diffrent scripts in a Test Batch Runner as a batch. its not showing any result. QTP only runs all the scripts n nothing else. B4 running the test batch i have done all the settings, But still its not working.

2 Answers  

---

When i used this below script to insert value in the Datatable... At run time it was inserting the given value in the specified column, But after execution all those inserted values were cleared automatically... datatable("column name",sheetid)=value

1 Answers  

---