Oracle Application recorded as Java Addin -QTP

[sreekanth chilam]

Hi Naveen,

Currently no Oracle API function, method or property provides the necessary information for QTP to display how many records a Oracle table contains.

Fyi, there is a manual graphic user interface (GUI) notification used to indicate how many rows are being displayed as well as other messages. This control is a status bar normally located on the lower side of the Oracle application window

The usual syntax of such goes as “Record: 1/6” where the “1” represents the current index being reviewed from the currently displayed table and the “6” represents the total of rows or records available on the currently focused table.

1. Use the "OracleStatusLine" object provided by the Oracle Application to review such information.

Code:

Msgbox OracleStatusLine("...").GetROProperty("message")

2. If "OracleStatusLine" object doesn’t show all the required information, access the status bar with the Oracle’s backup recognition mechanism which is Java recognition:

Code:

Msgbox JavaWindow("...").JavaStaticText("...").GetROProperty("content")
    Or
set a = JavaWindow("...").JavaStaticText("...").Object.getItems
Msgbox a.mic_arr_get(0).getText

Try it out & see