Skip to content

DF_FIELD_FETCH_STATE

The fetch state of a column.

Level

Column

Supported by

The DataFlex SQL Drivers (SQL Server, DB2, and ODBC)

Type

Boolean, temporary

Access

Read / Write

Values

  • True
  • False

Syntax

Use cli.pkg
Get_Attribute DF_FIELD_FETCH_STATE of {tableNumber} {columnNumber} to {BooleanVariable}
Set_Attribute DF_FIELD_FETCH_STATE of {tableNumber} {columnNumber} to {True|False}

Remarks

This column attribute indicates if individual columns are selected or not. There is a special field number keyword to set this attribute for all columns in a table at once: DF_ALL_COLUMNS.

Set_Attribute DF_FIELD_FETCH_STATE Of MyTable.File_Number DF_ALL_COLUMNS To False
Set_Attribute DF_FIELD_FETCH_STATE Of MyTable.File_Number 1 To True
Set_Attribute DF_FIELD_FETCH_STATE Of MyTable.File_Number 2 To True
Set_Attribute DF_FIELD_FETCH_STATE Of MyTable.File_Number 3 To True

The code above sets the fetch state for all columns off and then sets the fetch state for the first three columns on. This means that only the first three columns will be fetched from the back end. This attribute can be used to improve performance.

When a table is opened, the attribute is automatically set to true for all columns (all columns are fetched after opening). For more information on using this attribute, see the Selective Column Fetching section.