DISABLE_SELECT_COLUMNS_ERRORS

Applies to: ORAFlex SQLFlex MYSQLFlex PGFlex DB2Flex

When using SELECT_COLUMNS_FIND to limit the number of columns to fetch, the framework might still ask for columns that you do not need. As a result you’ll end up getting runtime errors you do not want to see. This command gives you the ability to stop reporting errors for querying for data from columns that are not part of the query.

DISABLED_SELECT_COLUMNS_ERRORS DISABLED will disable the errors, use ENABLED to turn the error messages back on.

By default triggering error messages on unknown columns is ENABLED

Syntax

DISABLE_SELECT_COLUMNS_ERRORS {ENABLED|DISABLED}

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