Skip to content

SetFetchAllColumns - cTableColumnFetchHelper

This sets the DF_FILE_FETCH_ALL_COLUMNS attribute for all tables to the value of bFetchAll.

Type: Procedure

Parameters

Parameter Type Description
bFetchAll Boolean Boolean value that DF_FILE_FETCH_ALL_COLUMNS should be set to

Syntax

Procedure SetFetchAllColumns Boolean bFetchAll

Call Example

Send SetFetchAllColumns bFetchAll

Description

This sets the DF_FILE_FETCH_ALL_COLUMNS attribute for all tables to the value of bFetchAll.

// First you carefully set the columns you want to be
// selectively fetched when all selected fetching is used.
Send SetColumnsToFetch
// this allows selected fetching
Send SetFetchAllColumns of oFetchHelper to False
:
:
// this enables all fetching
Send SetFetchAllColumns of oFetchHelper to True
:
:
// this again allows selected fetching use the same
// selected columns defined above
Send SetFetchAllColumns of oFetchHelper to False

When pbUseAllTables is true, all open tables are affected by this operation. When this property is false, only the tables added to this object's list are affected.

This message should be sent after files are opened.