MergeVirtual Method for LCFieldlist

This method merges two fieldlists to create new mapping and virtual fieldlists.

Note: This method is provided for backward compatibility. We recommend that you use either the Map or MapName methods for merging fieldlists and creating new mappings.

Defined In

LCFieldlist

Syntax

Call fldList. MergeVirtual (nameFieldList, dataFieldList, MergeFlags, virtualCode, virtualFieldList)

Parameters

Parameters are described in the following table.

Parameter

Description

nameFieldlist

LCFieldlist. Source fieldlist containing the field list of names for the new fieldlist.

dataFieldlist

LCFieldlist. Source fieldlist containing the referenced data for the new fieldlist.

mergeFlags

Long. By default, both fieldlists must have the same number of fields, and those fields are mapped by position (first to first, second to second, an so on). Use MergeFlags to alter this default behavior. Zero or more of the following values are ORed together:

LCMERGEF_MAP_NAME -- Match source and destination fields by field name instead of by position. (See Comment.)

LCMERGEF_DATA_LOSS -- Ignore fields in dataFieldList that have no corresponding field in NameFieldlist.

LCMERGEF_NAME_LOSS -- Ignore fields in nameFieldList that have no corresponding field in DataFieldlist.

LCMERGEF_FETCH -- Ignore fields with the LCFIELDF_NO_FETCH flag set.

LCMERGEF_INSERT -- Ignore fields with the LCFIELDF_NO_INSERT flag set.

LCMERGEF_UPDATE -- Ignore fields with the LCFIELDF_NO_UPDATE flag set.

LCMERGEF_REMOVE -- Ignore fields with the LCFIELDF_NO_REMOVE flag set.

LCMERGEF_CREATE -- Ignore fields with the LCFIELDF_NO_CREATE flag set.

LCMERGEF_DROP -- Ignore fields with the LCFIELDF_NO_DROP flag set.

LCMERGEF_KEY -- Include fields with the LCFIELDF_KEY flag set.

virtualCode

Long. Connect or Connector code to separate fields with a matching virtual code into virtualFieldList.

virtualFieldlist

LCFieldlist. New fieldlist, containing fields with virtual codes matching virtualCode.