Value Property

Applies to TestComplete 14.72, last modified on April 22, 2021

Description

Project, project suite and keyword test variables of the DB Table type provide access to various data storages and let you iterate through data rows. Use the Value property to obtain a column value from the data storage DBTableVariable provides access to.

Declaration

DBTableVariableObj.Value(Column)

Read-Only Property Variant
DBTableVariableObj An expression, variable or parameter that specifies a reference to a DBTableVariable object
Column [in]    Required    String    

Applies To

The property is applied to the following object:

Parameters

The property has the following parameter:

Column

Specifies the name of the needed column:

  • For database tables and queries, these are the field names. To find the names, open the needed table or query in the database editor.
  • For Excel and CSV files, column names are specified by the first data row. To determine the names, open your Excel workbook or CSV files in Microsoft Excel or in a text editor correspondingly.

Another way to determine column names is to use the ColumnName property of the DBTableVariable object. This property returns the column name by the column's index (zero-based).

If the specified column does not exist, an error occurs.

Note:

If you use Python or DelphiScript, you should enclose the parameter of the Value property in square brackets: Value[Column].

Property Value

The value of the specified column.

Remarks

The DBTableVariable object contains methods that let you iterate through data rows. The Value property specifies the column values of the current data row. To iterate through rows, use the Next, IsEOF and Reset methods. See Variables of the DB Table Type.

Example

For an example of the IsEOF method's use, see Variables of the DB Table Type.

See Also

Variables of the DB Table Type
ColumnName Property
ColumnCount Property
Next Method
Reset Method
IsEOF Method

Highlight search results