SelectedFields

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

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.

Dim allnames as String

If OptionButton1 = True Then

allnames = "msa_desc, population"

allnames = "msa_desc, prev_population"

VAccess1.SelectedFields = allnames

'we must call getFirst to establish valid position

VAccess1.GetFirst

'must invoke the Init method after

'changing SelectedFields

VAccess1.GetNextExtended

Affects: SelectedRecords, CacheRows, Columns, ColumnName

Affected by: SelectedRecords, ExtendedOps, Init