in my database haveing 3X3 (manas having 3 rows 3 colums) i
want to test only (2nd row 3colum) bit how to test either
script or any automation plz explain? (Chandana)
Answers were Sorted based on User's Feedback
Answer / chandana
Hi Sasi
This is chandana, can u expline me using query r script
statement ,it is very use ful for me.............
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / chandana
Hi Nanda,
we r using oracal DB..............so can u write the script
Plz.
| Is This Answer Correct ? | 0 Yes | 0 No |
ple try this.
set c=createobject("ADODB.connection")
c.open "name of DB"
set r=a.execute("select * from emp(table name))
for i=0 to r.fields.count-1
print r(i).value 'r(6) for 3x3 matrix hard coded value
next
c.close
Name:Manjunatha.H
My no:8970870702
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / ssasi
hai chandana your query is very important in realtime iam
working in infogain in noida as a testengineer
with using value statement we can write this query
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / sandip
hi,
use this query
select * from emp(table name) where rownum<=2;
| Is This Answer Correct ? | 0 Yes | 2 No |
Answer / shiavani
hi,
use this query
select * from emp(table name) where rownum<2;
| Is This Answer Correct ? | 0 Yes | 3 No |
Answer / sailaja
Select column name from table name where row =2 and column
=3
i ynk this is the query to test the particular column.
| Is This Answer Correct ? | 0 Yes | 3 No |
How can we close all webbrowsers which are opened in out desktop?
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
How can we extract data like "Details","Result","Time" from the 'Run Error' result generated in QTP after run time errors are generated during a run & import the details etc...into excel sheet
i've installed qtp9.2 on Windows 7. Recording and everything no problem. But when i am saving the test, it is not happening. it says 'general error while saving'. But teh test is getting saved but as a folder with lock icon. When i wanted to open it, it is jst showing as a locked folder but not as a test. Somebody help me out plz
What is the syntax to use out of two characters. Pls anybody can give the answer.. Thanks in advance...
how to identify the objects if application consists of objects that have same properties.
How do u write a regular expression for date (dd/mm/yyyy) field?
Suppose u write test case in Excel sheet . how u open that test case in Test Director?
what is standalone database
It seems Interview questions from Ordain Solutions are almost BASIC LEVEL-Easy. I am asking one tough question..(I think.. May be easy for some people) In recorded script the - WebLink("cityinfo") In reality, the WebLink name is "generalinfo" How you can write function to click that changed web link. NOTE: This functin should work with any Dynamic text link. I will post the answer later.
What is qtpro? What is quick test pro? What is a quick test professional?
When to use descriptive programming?