For QTP,Object Repository is just like a  Brain of Human.
It acts as a memory for QTP.
so if memory is empty means it can do any thing.

So If QTP has to test on any object means ,those objects 
should be identified by QTP & Should get stored in Object 
Repository.

If u record any Operation on any objects of 
appl,automatically script  will be generated Parallelly 
objects also will be stored in Object Repository.

One way is there in which we can write the script directly 
without having Objects in Object Repository & run the 
script --- i.e Descriptive Programming.

Hi sreekanth,

     hear object repository is not empty,even though if we 
took new test what ever objects r object repository will 
not remove until unless u could not deleted.

    i think when the script in run time the application is 
in disable condistion, when the application calls in run 
time test will run sucessfuly.

After pasting the script in new test, just load the object
repository of that script into new test. Then Run.

For loading the OR into new test,
First you have to save the OR in previous test.
Then In new test goto test-settings-ResourceTab-select
Shared radio button and browse the OR(Previously saved)and
select set as defauly-apply-OK..


You will get the results.

In the expert view script will describe the action we 
perform. To perform that action it should have that 
particular object in the object repository. So before 
scripting in the expert view what u should do is go to 
active screen and highlight the object and right click and 
select view/add to object repository. In the object 
repository property window it will show its logical name 
and class highlighted and click ok. This will add object to 
the object repository.

Hi,
When u Record ur test in QTP.  The Objects are stored in 
the repository as Pre-action mode.So first u have to save 
the repository as shared Repository in a common location. 
Then when u copy the script and paste in the new test. u 
have to associate the shared repository into that test. 
Then ur script refer the objects from the shared repository.
To share ur local(peraction) repository go to resourse menu 
in the menu tab and click the object repository menu. ther 
u can find the export the Local menu. once u click the 
menu. the tool will ask for saving the repo in the common 
location.

Pls mail me if u have any queries.

Hi Ss,

First we have to add all the objects of the application to 
the objects repository by manually and then only we have to 
write the test script and will run.

eg:

select top2 *  from tablename
this table retrive only second row only

from 2nd row if u want only number and name

then like this we have to write
eg:
select top2 empno,ename from emp

Here you go,

  for example , consider one EPmloyee table , to get a 2nd 
row :

 General syntax :
  
   Select < fields names > from <table name > where rownum 
= <row ID>

 Ex : select Ename , Eid , Designation from Employee where 
rownum=2

My answer will work in Oracle SQL but not sure in MS-SQL. 
Query is:
 
  select * from tablename where rownum=2;

rownum is the pseudo-column in oracle sql.

HI guys 

THis Is Karthik Rahul


I think to select the data from second row of a particular
table, we must know at least one coloumn value on that
particular table......

if it is wrong pl. send da correct one ro my mail
karthik_lboy@yahoo.co.in

9985315383 Hyderabad

hybrid framework
modular framework
keyword driven framework
linear frame work
dont  say ther r only 4 frameworks in qtp

If we want to test the same functionality more than 13times 
manually, we will go for Automation testing. 
And also if the build is stable for testing then only we 
can go for Autonlation testing.

TC 1:- successful card insertion.
TC 2:- unsuccessful operation due to wrong angle card 
insertion.
TC 3:- unsuccessful operation due to invalid account card.
TC 4:- successful entry of pin number.
TC 5:- unsuccessful operation due to wrong pin number
entered 3 times.
TC 6:- successful selection of language. 
TC 7:- successful selection of account type.
TC 9:- successful selection of withdrawal option.
TC 10 :- successful selection of amount.
TC 11:- unsuccessful operation due to wrong denominations.
TC 12:- successful withdrawal operation.
Tc 13 :- unsuccessful withdrawal operation due to amount
greater than possible balance.
TC 14 :- unsuccessful due to lack of amount in ATM.
TC 15 :- unsuccessful due to amount greater than the day 
limit.
TC 16 :- unsuccessful due to server down.
TC 17 :- unsuccessful due to click cancel after insert card.
TC 18:- unsuccessful due to click cancel after insert card
and pin no.
TC 19:- unsuccessful due to click cancel after language
selection,account type selection,withdrawal selection, enter
amount

QTP9.2, QC9.2(Test director and quality center both are 
same), winrunner8.2

Winrunner 9.2 is the latest version now

Test case is for to test a specific functionality of an 
application where as test matrix/tracebility matrix is used 
when ever there is an ambiguity or contravesal situation 
arieses then one has to show all the relevent document to 
defined himself  for example .suppose we got a defect  for 
that we need to show all the revelent doc. like 
BDD,UCD,FPD,MTCD,DTCD,TCD etc,. as proof for which test 
case we got that bug

iam taking table name as emp. this is to find out nth salary
  eg: select * from emp
 where n-1 = (select count(*) from emp e 
 where emp.salary<e.salary)

in place of n-1 you can keep zero for first hight salary 
and 1 for second hightest salary.....etc

SELECT [column_list], ROWNUM
FROM (SELECT [column_list]
FROM table
ORDER BY Top-N_column)
WHERE ROWNUM <= N

select top 1 salary from(select Distinct top 2 salary from
employee order by salary desc)order by salary

Hi...
here is the query to find out the n'th maximum salary

note: 1.'emp' is Table name & 'sal' is column name.
      2.'distinct' is used for finding the unique value
      3.'count' is for counting the values.

Query: 
------

SELECT * from emp 
where sal = (SELECT distinct(sal) from emp x 
             where &n = (SELECT count(distinct(sal)) from 
emp  where sal >= x.sal));