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

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

0 Answers  

---

Hi I able to record IE object but not able to record mozilla firefox 3 object using QTP 10. i don know wats the problem????

2 Answers  

---

What is the architecture of framework

0 Answers  

---

If I am scripting Web-based Surveys using QTP that open up differently but at the exact same point require a username and password can I automate that username and password for all the surveys some how using QTP?

0 Answers  

---

Please provide specific examples of advanced/creative usage of QTP, including how impact & benefits for your project

0 Answers   T Mobile,

---

In QTP 8.2 there are lot of check points is this same in latest version QTP 9.5 ?

2 Answers  

---

Ehat is the descriptive programing in QTP?

4 Answers  

---

what type of run time errors you get while you ar edoing rpg program?

0 Answers  

---

In QTP, Give the difference of Global sheet and Local sheet in datatable?

3 Answers  

---

Can an action have 2 shared object repositories associated with them? In that case, if two of them contain the same object, which one will be considered?

0 Answers  

---

what is the difference between wait and wait function

1 Answers   TCS, Wipro,

---

Is there any site to download QTP....otherwise tell me the way how to get the QTP sofware??????????????????? Thnx in advance

5 Answers   Cegonsoft,

---