Active TopicsActive Topics  Display List of Forum MembersMemberlist  CalendarCalendar  Search The ForumSearch  HelpHelp
  RegisterRegister  LoginLogin


 One Stop Testing ForumTesting Tools @ OneStopTestingWinRunner @ OneStopTesting

Message Icon Topic: WinRunner Questions and Answers Part-8

Post Reply Post New Topic
Author Message
Mithi25
Senior Member
Senior Member
Avatar

Joined: 23Jun2009
Online Status: Offline
Posts: 288
Quote Mithi25 Replybullet Topic: WinRunner Questions and Answers Part-8
    Posted: 12Aug2009 at 11:10pm
HTML clipboard

Winrunner Question 71: How do you convert a database file to a text file?

How do you convert a database file to a text file?
You can use Data Junction to create a conversion file which converts a database to a target text file.

Winrunner Question 72: How do you parameterize database check points?

How do you parameterize database check points?
When you create a standard database checkpoint using ODBC (Microsoft Query), you can add parameters to an SQL statement to parameterize the checkpoint. This is useful if you want to create a database checkpoint with a query in which the SQL statement defining your query changes

Winrunner Question 73: How do you create parameterize SQL commands?

How do you create parameterize SQL commands?
  • A parameterized query is a query in which at least one of the fields of the WHERE clause is parameterized, i.e., the value of the field is specified by a question mark symbol ( ? ). For example, the following SQL statement is based on a query on the database in the sample Flight Reservation application:


SELECT Flights.Departure, Flights.Flight_Number, Flights.Day_Of_Week FROM Flights Flights WHERE (Flights.Departure=?) AND (Flights.Day_Of_Week=?)

     SELECT defines the columns to include in the query.
     FROM specifies the path of the database.
WHERE (optional) specifies the conditions, or filters to use in the query.
Departure is the parameter that represents the departure point of a flight.
Day_Of_Week is the parameter that represents the day of the week of a flight.

  • When creating a database checkpoint, you insert a db_check statement into your test script. When you parameterize the SQL statement in your checkpoint, the db_check function has a fourth, optional, argument: the parameter_array argument. A statement similar to the following is inserted into your test script:


db_check("list1.cdl", "dbvf1", NO_LIMIT, dbvf1_params);

The parameter_array argument will contain the values to substitute for the parameters in the parameterized checkpoint.

Winrunner Question 74: Explain the following Winrunner Commands

Explain the following commands
  • db_connect - to connect to a database
db_connect(<session_name>, <connection_string>)
  • db_execute_query - to execute a query
db_execute_query ( session_name, SQL, record_number );
[record_number  is the out value]
  • db_get_field_value - returns the value of a single field in the specified row_index and column in the session_name database session.
db_get_field_value ( session_name, row_index, column );
  • db_get_headers - returns the number of column headers in a query and the content of the column headers, concatenated and delimited by tabs.
db_get_headers ( session_name, header_count, header_content );
  • db_get_row - returns the content of the row, concatenated and delimited by tabs.
db_get_row ( session_name, row_index, row_content );
  • db_write_records - writes the record set into a text file delimited by tabs.
db_write_records ( session_name, output_file [ , headers [ , record_limit ] ] );
  • db_get_last_error - returns the last error message of the last ODBC or Data Junction operation in the session_name database session.
db_get_last_error ( session_name, error );
  • db_disconnect - disconnects from the database and ends the database session.
db_disconnect ( session_name );
  • db_dj_convert - runs the djs_file Data Junction export file. When you run this file, the Data Junction Engine converts data from one spoke (source) to another (target). The optional parameters enable you to override the settings in the Data Junction export file.
db_dj_convert ( djs_file [ , output_file [ , headers [ , record_limit ] ] ] );

Winrunner Question 75: What check points you will use to read and check text on the GUI and explain its syntax?

What check points you will use to read and check text on the GUI and explain its syntax?
You can use text checkpoints in your test scripts to read and check text in GUI objects and in areas of the screen. While creating a test you point to an object or a window containing text. WinRunner reads the text and writes a TSL statement to the test script. You may then add simple programming elements to your test scripts to verify the contents of the text.

You can use a text checkpoint to:
 
  1. Read text from a GUI object or window in your application, using obj_get_text and win_get_text
     
  2. Search for text in an object or window, using win_find_text and obj_find_text
     
  3. Move the mouse pointer to text in an object or window, using obj_move_locator_text and win_move_locator_text
     
  4. Click on text in an object or window, using obj_click_on_text and win_click_on_text

Winrunner Question 76: Explain Get Text checkpoint from object/window with syntax?

Explain Get Text checkpoint from object/window with syntax?
  • We use obj_get_text (<logical_name>, <out_text>) function to get the text from an object
     
  • We use win_get_text (window, out_text [, x1, y1, x2, y2]) function to get the text from a window.

Winrunner Question 77: Explain Get Text checkpoint from screen area with syntax?

Explain Get Text checkpoint from screen area with syntax?

We use win_get_text (window, out_text [, x1, y1, x2, y2]) function to get the text from a window.

Winrunner Question 78: Explain Get Text checkpoint from selection (web only) with syntax?

Explain Get Text checkpoint from selection (web only) with syntax?

Returns a text string from an object.

web_obj_get_text (object, table_row, table_column, out_text [, text_before, text_after, index]);
  • object     The logical name of the object.
     
  • table_row     If the object is a table, it specifies the location of the row within a table. The string is preceded by the # character.
     
  • table_column     If the object is a table, it specifies the location of the column within a table. The string is preceded by the # character.
     
  • out_text     The output variable that stores the text string.
     
  • text_before     Defines the start of the search area for a particular text string.
     
  • text_after     Defines the end of the search area for  a particular text string.
     
  • index     The occurrence number to locate. (The default parameter number is numbered 1).



Post Resume: Click here to Upload your Resume & Apply for Jobs

IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.219 seconds.
Vyom is an ISO 9001:2000 Certified Organization

© Vyom Technosoft Pvt. Ltd. All Rights Reserved.

Privacy Policy | Terms and Conditions
Job Interview Questions | Placement Papers | Free SMS | Freshers Jobs | MBA Forum | Learn SAP | Web Hosting