Browser("Yahoo! Mail: The best").Page("(2 unread) Yahoo! Mail").Link("Inbox (2)").Clickthis is the recorded script i get after performing the action on yahoo mail..now when i run the test again ...the page title and link name changes as the no. of emails in inbox increases...so the error says cannot find the object.can someone please tell me what regular expressions i should used for this script ?

allen hu

 Profile Answers by allen hu Questions by allen hu

• Jun 12th, 2010

You do not need to change anytihng in your scripts.But you need find that link in object repository and update the value of the attribute display in it which to identify the object, such as 'innertext'.You need regular expression of this value in order to make the QTP can smart indentify the object.

srivani123

 Profile Answers by srivani123 Questions by srivani123

• Jan 23rd, 2009

Today I tried after read your question. You know what I did, I just changed the object name in the object repository file.ie.when you are recording if is inbox(4), then running it must be inbox(3) in ...

Answer Question  Select Best Answer

What is the difference between View and Stored Procedure? Can views accept input parameters as stored procedure? If yes,how could I do that? I am new to database and working on MS SQL,if someone could suggest me good reference websites then that would be great.

Read Best Answer

Editorial / Best Answer

atdhdrolla  

 Profile Answers by atdhdrolla Questions by atdhdrolla

• Member Since Mar-2007 | Jul 16th, 2008

---

View - A View in simple terms is a subset of a table. It can be used to retrieve data from the tables, Insert, Update or Delete from the tables. The Results of using View are not permanently  stored in the database.

Stored Procedure -  A stored procedure is a group of SQL statements which can be stored into the database and can be shared over the netwrok with different users.

Leena Roja

• Jul 9th, 2015

Views are virtual tables or subset of permanent tables for easier access of data which is stored in multiple tables. Views contains rows, columns just like a real table. The fields in a view are noth...

Test

• Oct 16th, 2013

View does not have parameters , SP can have input / output parameters . View is another way to view table data . SP is pre-compiled object which can change /add data into tables.

Improve Answer

I Tried by giving......................... ALTER table table name rename column tocolumn name was changed but it's not giving entire table with altered column name.It's giving only the altered column.

skcwebworld

 Profile Answers by skcwebworld Questions by skcwebworld

• Aug 26th, 2015

In T-SQL its not possible to rename the column name therefore use sp_rename

malapati

 Profile Answers by malapati Questions by malapati

• Oct 8th, 2008

to change name of one column   alter  table  <table name>rename column <old columnname> to <new columnname>;if we want to change more than one column  a...

Answer Question  Select Best Answer

What can you tell about the project if during testing you found 80 bugs in it?

ashishks

 Profile Answers by ashishks Questions by ashishks

• Sep 9th, 2009

Project with 80 bugs is very common. Also it depends on the severity of the bug.

atdhdrolla

 Profile Answers by atdhdrolla Questions by atdhdrolla

• Jun 13th, 2008

A Project with large number of defects doesn't mean that the development was not accurate or it is not developed as per requirements. below is a case when we faced large number of defects--we...

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

nirmal1in  

 Profile Answers by nirmal1in Questions by nirmal1in

• Member Since Jan-2010 | Jan 17th, 2010

---

This can be accomplished in following way:

Example: table - emp

For First n rows:

SELECT * FROM
(SELECT empno,ename,job,row_number() over (order by ename desc) a
FROM emp) x
WHERE x.a < 5 --- say n is 5 display first 5 records

For last n rows:

SELECT * FROM
(SELECT empno,ename,job,row_number() over (order by ename) a
FROM emp) x
WHERE x.a < 5

FROM )WHERE .a<

This query can be used for finding nth row also say n = 5

SELECT * FROM
(SELECT empno,ename,job,row_number() over (order by ename desc) a
FROM emp) x
WHERE x.a = 5

deepthi

• May 17th, 2012

Code
SELECT rownum,a.*FROM(SELECT rownum,b.*FROM emp b ORDER BY rownum DESC) a WHERE rownum <&n;

Vasavi Katakam

 Profile Answers by Vasavi Katakam Questions by Vasavi Katakam

• Jul 18th, 2011

For First N Rows:

Code

1.  
2. SELECT top 5 * FROM table_name
3.  

For Last N Rows:

Code

1.  
2. SELECT * FROM
3. (SELECT top 5 * FROM
4. table_name
5. ORDER BY Columnname DESC)
6. ORDER BY Columnname ASC
7.  

Improve Answer

aditya_12

 Profile Answers by aditya_12 Questions by aditya_12

• Apr 21st, 2010

You can load function library at run time using following code.. Dim qtpApp Dim funcLibSet qtpApp = CreateObject("QuickTest.Application")qtpApp.LaunchqtpApp.visible = TrueqtpApp.Open "c...

venkat_siqes

 Profile Answers by venkat_siqes Questions by venkat_siqes

• Apr 19th, 2010

You can do like thisExecuteFile "Path Of File"Call FunctionNameRegardsVenkat

Answer Question  Select Best Answer

atdhdrolla

 Profile Answers by atdhdrolla Questions by atdhdrolla

• Mar 7th, 2007

ExpectedItem = "UK"WebListItemCount = Browser(....).Page(...).WebList(...).GetROProperty("items count")For i = 0 To (WebListItemCount - 1)ItemFromList = Browser(....).Page(...).Web...

Answer Question  Select Best Answer

atdhdrolla

 Profile Answers by atdhdrolla Questions by atdhdrolla

• Mar 7th, 2007

yes it is possible to add objects during RuntimeFor QTP version 8.2 Step->Object RepositoryIt will open the object repository; please click on Repository and use add objects button to add required ...

Mandeep

• Feb 22nd, 2007

Yes you can add objects in the object repository during runtime..

Answer Question  Select Best Answer

atdhdrolla

 Profile Answers by atdhdrolla Questions by atdhdrolla

• Mar 15th, 2007

This is a very obvious problem with .Net application. Replay and Recorded snap shots doesn't match.Generally i do it as followingI try to download data during run time:File_Size = web_get_int_prop...

Answer Question  Select Best Answer

atdhdrolla

 Profile Answers by atdhdrolla Questions by atdhdrolla

• Mar 7th, 2007

A Startup script to launch QTP, Open the test , Create a result folder and run the test may look like this:Dim App Set App = CreateObject("QuickTest.Application")     &nb...

RAJAGOPAL REDDY

• Dec 14th, 2006

Yes,We can put start applications URL/Address/Exe file path in the default record or run settings for Windows/WEB. Once opens QTP immediately that particular application or URL will open.Thanks-RAJAGOPAL REDY Email: Reddy_rajagopal@yahoo.co.in

Answer Question  Select Best Answer

ramaraogoud

 Profile Answers by ramaraogoud Questions by ramaraogoud

• Apr 14th, 2007

Hai Ziauddin,  Build In Functions means ,That are default Functions ,In this we Have 1)Action Iterations2)Product Dir3)Product Name4)Product Version5)Test Iterationetc

atdhdrolla

 Profile Answers by atdhdrolla Questions by atdhdrolla

• Mar 8th, 2007

A user-defined internal environment variable: These variables are saved with the test and are accessible only within the test in which they were defined. You can create or modify internal, user-defin...

Answer Question  Select Best Answer

Anjaneyulu pigili

 Profile Answers by Anjaneyulu pigili Questions by Anjaneyulu pigili

• May 10th, 2011

We can get by using Child objects

Vimala Ns

 Profile Answers by Vimala Ns Questions by Vimala Ns

• May 9th, 2011

Count =Browser("name:=Astrology - Yahoo! India News").Page("title:=Astrology - Yahoo! India News").WebList("innertext:= All News Yahoo! News Only").GetROProperty("items count")msgbox count

Answer Question  Select Best Answer

atdhdrolla

 Profile Answers by atdhdrolla Questions by atdhdrolla

• Mar 8th, 2007

I don't the nature of your application but you can always Use Exit statement to come out of a function, Component, local action or global action.

raghu

• Jan 3rd, 2007

You can use the statement "On Error Resume Next" when ever an error occurs qtp ignores the step and moves to next step, if you want to see the error number and description use the codeif Err.Number0 thenmsgbox err.numbermsgbox err.description

Answer Question  Select Best Answer

kirandba

 Profile Answers by kirandba Questions by kirandba

• Apr 1st, 2010

Use below query to know index usage in SQL ServerSELECT   OBJECT_NAME(S.[OBJECT_ID]) AS [OBJECT NAME],          I.[NAME] AS [INDEX NAME],   ...

atdhdrolla

 Profile Answers by atdhdrolla Questions by atdhdrolla

• Jun 12th, 2008

sp_helpindex works for SQL server 2005

Answer Question  Select Best Answer

atdhdrolla

 Profile Answers by atdhdrolla Questions by atdhdrolla

• Jun 18th, 2008

You can use size property. Remember the object has to be a File or Folder type object. the return value will be the size in bytes.

prashanth

• Sep 4th, 2007

You can put a checkpoint on the size in terms of the number of bytes that are transferred to the user. If the size exceeds the normal level you can consider that as a excess data else it is within the stipulated data.

Answer Question  Select Best Answer

sharmi27

 Profile Answers by sharmi27 Questions by sharmi27

• Jul 22nd, 2010

Test SpecificationTest ReportDefect ReportReview reportRelease notes

vk1978

 Profile Answers by vk1978 Questions by vk1978

• Apr 17th, 2009

Test Plan docTest Cases docreview reportTraceability MatrixTest LogBug reportTest Summary report Test's to be verified Test Scenariosare the test deliverables

Answer Question  Select Best Answer

Sreedhar Reddy

• May 18th, 2014

By Creating WSH(Windows ShellScript Host) Object We can open notepad.

Code
set oWSH = CreateObject("wscript.shell")
oWSH.run "obsalutepath of notepad"

velmuruganrtesting

 Profile Answers by velmuruganrtesting Questions by velmuruganrtesting

• Oct 28th, 2013

Code
set FSO = CreateObject("Scripting.FileSystemObject")
Set FSNote = FSO.CreateTextFile("C:hello.txt",True)
FSNote.Write "This is my text File"
FSNote.Close
Set FSO = Nothing

Answer Question  Select Best Answer

atdhdrolla

 Profile Answers by atdhdrolla Questions by atdhdrolla

• Jun 12th, 2008

Just a lil change to Sivakumar's script dataSource = ExcelFilePath & ExcelFileNameSet oCon = CreateObject("ADODB.Connection")oCon.Provider = "Microsoft.Jet.OLEDB.4.0"oCon.C...

sivaoff

 Profile Answers by sivaoff Questions by sivaoff

• Aug 29th, 2007

hi sivakumar!I did the as u said but i got a error msg like"[microsoft][ODBC Excel Driver] The Microsoft Jet database engine could not find the object "Sheet1$".makesure the object exis...

Answer Question  Select Best Answer