DbTable Object

Description

The database table object used in database checkpoints.

Methods

Method ExistChecks that an object exists.
Method GetTOPropertyReturns the value of the specified description property from the test object description.
SetTOPropertySets the specified value of a description property for an object.

Back to top

Exist Property

Description

Checks that an object exists.

Syntax

DbTable(description).Exist([Timeout])

Argument

Type

Description

Timeout

Number

Optional. The length of time to search for the object before returning a True or False value.

  • If a timeout value is specified, UFT One waits until it finds the object or until the timeout is reached.

  • If the value 0 is specified, the method returns the True or False value immediately.

  • If no value is specified, the value specified in the Test Settings dialog box for the Object Synchronization Timeout is used for tests.

For more details on the Object Synchronization Timeout, see the Micro Focus UFT One User Guide

Return Value

Boolean

DbTable("DbTable").Check CheckPoint("DbTable")
IsExists = DbTable("DbTable").Exist (0)

Back to top

GetTOProperty Method

Description

Returns the value of the specified description property from the test object description. The value is taken from the Object Repository..

Note: You can use the GetTOProperty method to retrieve the values of only those properties that are included in the test object description. Specifying a property that is not included in the test object's description results in a warning status for the step and the test. For more details on adding properties to a test object description, see the Micro Focus UFT One User Guide.

Syntax

DbTable(description).GetTOProperty(Property)

Argument

Type

Description

Property

String

The description properties to retrieve from the object description.

Return Value

Variant

The following example uses the GetTOProperty method to retrieve and view the value of the database's Source property before and after it is modified.

DbTable("DbTable").Check CheckPoint("DbTable")
IsExists = DbTable("DbTable").Exist (0)
If IsExists Then
    Dim SQL
    SQL = DbTable("DbTable").GetTOProperty ("Source")
    MsgBox SQL
    DbTable("DbTable").SetTOProperty "Source", "SELECT * FROM ADDRESS"
    Dim NewSQL
    NewSQL = DbTable("DbTable").GetTOProperty ("Source")
    MsgBox NewSQL
End If

Back to top

Back to top

SetTOProperty Method

Description

Sets the specified value of a description property for an object.

Example: Notes:

SetTOProperty changes the property values used to identify an object during the test run. It has no effect on the Active Screen or the values saved in the Object Repository for the object.

Only properties that are included in the test object description can be set. For more details on adding properties to a test object description, see the Micro Focus Application Lifecycle Management User Guide.

Syntax

DbTable(description).SetTOProperty Property, Value

Argument

Type

Description

Property

String

The description properties to set.

Value

Variant

The value to assign to the listed property.

The following example uses the SetTOProperty method to modify the database table's Source property, and then retrieves and displays the new value.

DbTable("DbTable").Check CheckPoint("DbTable")
IsExists = DbTable("DbTable").Exist (0)
If IsExists Then
    DbTable("DbTable").SetTOProperty "Source", "SELECT * FROM ADDRESS"
    Dim NewSQL
    NewSQL = DbTable("DbTable").GetTOProperty ("Source")
    MsgBox NewSQL
End If

Back to top