RESET_FETCH_FIELDS¶

Applies to: ORAFlex SQLFlex MYSQLFlex PGFlex DB2Flex

This command is used to specify whether to retrieve all columns or no columns when performing a find. It is usually used with the command SELECT_COLUMNS_FIND to reset the column fetching. This command can either be set to DF_FETCH_TRUE, which will fetch all columns or set to DF_FETCH_FALSE, which will fetch no columns.

Syntax

RESET_FETCH_FIELDS {FileNumber} {DF_FETCH_TRUE/DF_FETCH_FALSE}

Parameter

Description

FileNumber

The number of the file

DF_FETCH_TRUE

fetch all columns

DF_FETCH_FALSE

fetch no columns

Example

Open Customer
RESET_FETCH_FIELDS  CUSTOMER DF_FETCH_FALSE
SELECT_COLUMNS_FIND CUSTOMER CUSTOMER_NUMBER NAME
DISABLE_SELECT_COLUMNS_ERRORS DISABLED

Clear Customer
Repeat
   Find Gt Customer by Index.1
   If (Found) Showln Customer.Customer_Number '-' Customer.Name
Until (Not(Found))

RESET_FETCH_FIELDS Customer DF_FETCH_TRUE