OracleTable Object

Description

An Oracle block of records.

IMPORTANT

When learning an Oracle table, UFT One identifies the table columns as being part of a table only if the columns have a description property (usually the column name). If a particular column does not have a description property, then its cells are recognized as separate controls and are learned as separate test objects.

Operations

The sections below list the built-in methods and properties that you can use as operations for the OracleTable object.

Note: You can also view a list and descriptions of the OracleTable description properties, for use in object repository descriptions, programmatic descriptions, checkpoint and output value steps, and as argument values for the GetTOProperty and GetROProperty methods.

Methods

Method ActivateRecordActivates a specified record.
Common Method CaptureBitmapSaves a screen capture of the object as a .png or .bmp image using the specified file name.
Common Method CheckChecks whether the actual value of an item matches the expected value.
Common Method CheckPropertyChecks whether the actual value of the specified object property matches the specified expected value within the specified timeout.
Common Method ChildObjectsReturns the collection of child objects contained within the object.
Common Method GetAllROProperties

Returns the collection of properties and current values from the object in the application.

Method ClickClicks the specified location with the specified mouse button.
Method EnterFieldEnters a value in a specific record field.
Method GetFieldItemReturns the test object representing a specified record field.
Method GetFieldValueRetrieves the value of a specified record field.
Common Method GetROPropertyReturns the current value of the description property from the object in the application.
Common Method GetTOPropertiesReturns the collection of properties and values used to identify the object.
Common Method GetTOPropertyReturns the value of the specified description property from the test object description.
Common Method HighlightHighlights the object in the application.
Method InvokeSoftkeyInvokes the specified Oracle softkey.
Method IsFieldEditableChecks whether the field is editable.
Method OpenDialogOpens a specified record field's associated dialog box.
Common Method OutputRetrieves the current value of an item and stores it in a specified location.
Common Method RefreshObjectInstructs UFT One to re-identify the object in the application the next time a step refers to this object.
Method SelectPopupMenuInvoke context menu and select the specified menu option.
Method SetFocusTransfers focus to a specified record field.
Common Method SetTOPropertySets the value of the specified description property in the test object description.
Common Method ToStringReturns a string that represents the test object.
Method VerifyFieldChecks that the value of a specified record field matches the specified value.
Common Method WaitPropertyWaits until the specified object property achieves the specified value or exceeds the specified timeout before continuing to the next step.

Properties

Common Property ExistChecks whether the object currently exists in the open application.

Back to top

 

ActivateRecord Method

Description

Activates a specified record.

Syntax

object.ActivateRecord (RecordNumber)

Arguments

ParameterDescription
RecordNumber Required. An integer value.
The number of the record (row). Record numbers start with 1.

Return Type

None.

Example

Back to top

 

Click Method

Description

Clicks the specified location with the specified mouse button.

Syntax

object.Click ([x], [y], [BUTTON])

Arguments

ParameterDescription
x Optional. An integer value.
The x-coordinate of the click. Note that the specified coordinates are relative to the upper left corner of the object. 
Default = micNoCoordinate (center of the object).
Default value = -1
y Optional. An integer value.

The y-coordinate of the click. Note that the specified coordinates are relative to the upper left corner of the object.
Default = micNoCoordinate (center of the object).

Tip: You can enter micNoCoordinate for the x and y argument values if you want to enter a value for the button argument without specifying x- and y- coordinates for the click. micNoCoordinate indicates the center of the object.


Default value = -1
BUTTON Optional. A predefined constant or number.
The mouse button used to click the object.
Default value = micLeftBtn

Return Type

None.

Example

Back to top

 

EnterField Method

Description

Enters a value in a specific record field.

Syntax

object.EnterField (RecordNumber, Column, Value, [WithValidation])

Arguments

ParameterDescription
RecordNumber Required. An integer value.
The number of the record (row). Record numbers start with 1.
Column Required. A Variant.
The name of the column. The column name (with quotes) or numeric index (without quotes) can denote the item. The first (left-most) column in a table is numbered 1.
Value Required. A Variant.
The value to enter in the record cell. Depending on the cell type, the following values can be used:
- Editable cell: text string
- Radio (option) group cell: The item value (with quotes) or numeric index (without quotes). The first item in a radio group is numbered 1.
- Poplist cell: The item value (with quotes) or numeric index (without quotes). The first item in a list is numbered 1. 
- Check box cell: "ON" "OFF", TRUE FALSE, or vbTrue vbFalse
WithValidation Optional. A Boolean value.
Specify whether to transfer the focus out of the cell after entering the value, thereby validating the value.
Possible values:
True or vbTrue: Transfers the focus out of the cell (default value)
False or vbFalse: Leaves the focus in the cell


Default value = True

Return Type

None.

Example

Back to top

 

GetFieldItem Method

Description

Returns the test object representing a specified record field.

Syntax

object.GetFieldItem (RecordNumber, Column)

Arguments

ParameterDescription
RecordNumber Required. An integer value.
Column Required. A Variant.

Return Type

An Object.

Back to top

 

GetFieldValue Method

Description

Retrieves the value of a specified record field.

Syntax

object.GetFieldValue (RecordNumber, Column)

Arguments

ParameterDescription
RecordNumber Required. An integer value.
The number of the record (row). Record numbers start with 1.
Column Required. A Variant.
The name of the column. The column name (with quotes) or numeric index (without quotes) can denote the item. The first (left-most) column in a table is numbered 1.

Return Type

A String value.

Note: If the specified record field contains a check box, the return value is "true" (check box is selected) or "false" (check box is cleared).

Example

Back to top

 

InvokeSoftkey Method

Description

Invokes the specified Oracle softkey.

Syntax

object.InvokeSoftkey (Softkey)

Arguments

ParameterDescription
Softkey Required. A String value.

The softkey function to perform. You can view the functions available in a specific form by pressing Ctrl+K in an Oracle Applications session. Softkey functions are not case sensitive.

The following functions can be specified:

NEXT FIELDCLEAR RECORDDISPLAY ERROR
PREVIOUS FIELDDELETE RECORDPRINT
CLEAR FIELDDUPLICATE RECORDCOUNT QUERY
UPINSERT RECORDUPDATE RECORD
DOWNNEXT SET OF RECORDSFUNCTION 0 
SCROLL UPNEXT RECORDFUNCTION 1 
SCROLL DOWNPREVIOUS RECORDFUNCTION 2 
EDITCLEAR BLOCKFUNCTION 3 
RETURNBLOCK MENUFUNCTION 4 
LIST OF VALUESNEXT BLOCKFUNCTION 5 
HELPPREVIOUS BLOCKFUNCTION 6 
EXITDUPLICATE FIELDFUNCTION 7 
SHOW KEYSCLEAR FORMFUNCTION 8 
COMMITENTER QUERYFUNCTION 9
NEXT PRIMARY KEYEXECUTE QUERYLIST TAB PAGES

Return Type

None.

IMPORTANT

Note: When you record this method on an OracleTable object, a SetFocus method is recorded first automatically.

Example

Back to top

 

IsFieldEditable Method

Description

Checks whether the field is editable.

Syntax

object.IsFieldEditable (RecordNumber, Column)

Arguments

ParameterDescription
RecordNumber Required. An integer value.
Column Required. A Variant.

Return Type

A Boolean value.

Back to top

 

OpenDialog Method

Description

Opens a specified record field's associated dialog box.

Syntax

object.OpenDialog (RecordNumber, Column)

Arguments

ParameterDescription
RecordNumber Required. An integer value.
The number of the record (row). Record numbers start with 1.
Column Required. A Variant.
The name of the column. The column name (with quotes) or numeric index (without quotes) can denote the item. The first (left-most) column in a table is numbered 1.

Return Type

None.

Example

Back to top

 

SelectPopupMenu Method

Description

Invoke context menu and select the specified menu option.

Syntax

object.SelectPopupMenu (Path)

Arguments

ParameterDescription
Path Required. A String value.
The path of the menu to open.

Return Type

None.

Example

Back to top

 

SetFocus Method

Description

Transfers focus to a specified record field.

Syntax

object.SetFocus (RecordNumber, Column)

Arguments

ParameterDescription
RecordNumber Required. An integer value.
The number of the record (row). Record numbers start with 1.
Column Required. A Variant.
The name of the column. The column name (with quotes) or numeric index (without quotes) can denote the item. The first (left-most) column in a table is numbered 1.

Return Type

None.

Example

Back to top

 

VerifyField Method

Description

Checks that the value of a specified record field matches the specified value.

Syntax

object.VerifyField (RecordNumber, Column, Value)

Arguments

ParameterDescription
RecordNumber Required. An integer value.
The number of the record (row). Record numbers start with 1.
Column Required. A Variant.
The name of the column. The column name (with quotes) or numeric index (without quotes) can denote the item. The first (left-most) column in a table is numbered 1.
Value Required. A Variant.
The value against which to verify the record cell value. Depending on the cell type, the following values can be used:
- Editable cell: text string
- Radio (option) group cell: The item value (with quotes) or numeric index (without quotes). The first item in a radio group is numbered 1.
- Poplist cell: The item value (with quotes) or numeric index (without quotes). The first item in a list is numbered 1. 
- Check box cell: "ON" "OFF", TRUE FALSE, or vbTrue vbFalse

Return Type

A Boolean value.

Example

Back to top

See also: