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
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