Answer Posted / 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

Write the code for,In the page screen we have total 10 Links,out of these I have to click 9th link

1263

---

write script for bitmap image?

1982

---

What if recovery scenarios is also failed for identify the alert ? (We are handling unexpected popup through recovery scenarios but if still recovery scenarios also failed than what should be the approach)

1502

---

Write a QTP script to enter a keyword in to Google search engine?

1004

---

Hi, Can anyone please tell me how to connect the QC with QTP using QTP script? Thanks in advance

1861

---

Please Don't mind .i want in detail the real time process i.e in each document what it contains.

1836

---

How you can make an action as re-usable action?

1067

---

Where you get the run time data table?

974

---

How to data driven test for Win objects in QTP ?

1877

---

I used the below code to open QTP through VBscript?But i can unable to Invoke QTP...PLZ help me with the correct code to invoke QTP through VBS with description of the code aswell. Dim qtApp 'As QuickTest.Application 'Declare the Application object variable Dim qtTest 'As QuickTest.Test 'Declare a Test object variable Dim qtResultsOpt 'Declare a Run Results Options object variable Set qtApp = CreateObject("QuickTest.Application") 'Create the Application object qtApp.Launch 'Start QuickTest qtApp.Visible = False 'Make the QuickTest application visible qtApp.Open "C:\form", True 'Open the test in read-only mode 'set run settings for the test Set qtTest = qtApp.Test qtTest.Run 'Run the test 'WScript.StdOut.Write "Status is: " & qtTest.LastRunResults.Status 'Check the results of the test run qtTest.Close 'Close the test qtApp.quit 'Close QuickTest Pro Set qtResultsOpt = Nothing 'Release the Run Results Options object Set qtTest = Nothing 'Release the Test object Set qtApp = Nothing 'Release the Application object

2853

---

Hi,All How to create a link in excel sheet using qtp

3370

---

what are the limitations of smart identification in qtp 9.0

2313

---

What is qtpro? What is quick test pro? What is a quick test professional?

1030

---

Give me detailed theritical explanation about keyword driven, hybrid framework, environment variables, hybrid frame work

1867

---

hi guys, pls tell me for testing institution training hub, hitech city is best or not?

1772

---