SELECT_COLUMNS_FIND¶

Applies to: ORAFlex SQLFlex MYSQLFlex PGFlex DB2Flex

This command is used to fetch only a certain number of fields while doing a “find”. When specifying the field number to start from and field number to end on, the find will only fetch the given fields from the record. It is important to always use this command after first deselecting all columns i.e. setting RESET_FETCH_FIELDS to DF_FETCH_FALSE. Also, after using this command, all columns need to be reselected i.e. setting RESET_FETCH_FIELDS to DF_FETCH_TRUE. Note that fields used as a part the index segment associated with the find will always be fetched regardless.

Syntax

SELECT_COLUMNS_FIND {FileNumber} {fieldStart} THRU {fieldEnd}

Parameter	Description
FileNumber	The number of the file
fieldStart	The field number to start the fetch from
FieldEnd	The field number to end the fetch at

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