SelectedFields

Applies to:

Description

Lists the fields to be returned in an extended fetch record set.

Remarks

Fields specified in the SelectedFields property correspond to Columns in the record set returned by an extended fetch operation.

Field names in the SelectedFields list must be valid field names for the table referenced by the VAccess control, and must be separated by commas.

Leaving this property blank will assign all of the fields defined for the data file to columns in the extended fetch record set. The columns will be ordered according to the offset of each field within the record (the same order in which the fields appear in the DDF definition for the file.)

If a value is specified for this property, the order of the columns returned will correspond to the order in which the fields are listed in the SelectedFields property, not necessarily in the order in which they occur in the DDF definition for the file.

The ExtendedOps property must be set to True to enable the extended operations capabilities of the VAccess control.

Example

Dim allnames as String 
If OptionButton1 = True Then 
  allnames = "msa_desc, population" 
else 
  allnames = "msa_desc, prev_population" 
End If 
VAccess1.SelectedFields = allnames 
'we must call getFirst to establish valid position 
VAccess1.GetFirst 
'must invoke the Init method after  
'changing SelectedFields 
VAccess1.Init 
VAccess1.GetNextExtended 

See Also:

Affects: SelectedRecords, CacheRows, Columns, ColumnName

Affected by: SelectedRecords, ExtendedOps, Init