Retrieving Individual Records
This section lists the properties, methods, and events which you can use to retrieve individual records.
Properties and Methods
Table 29
Properties and Methods for Retrieving Individual Records
Property or Method
Description
Buffer
Sets or returns the contents of a control’s current record buffer.
GetDirect
Returns a record using its physical position in the file.
GetEqual
Returns a record by an exact match to the current index.
GetFirst
Returns the first record in the current index path.
GetGreater
Returns the first record greater than the current key value in the current index path.
GetGreaterOrEqual
Returns the first record greater than or equal to the current key value in the current index path.
GetLast
Returns the last record in the current index path.
GetLess
Returns the last record in the current index path containing a value less than the value specified for the key fields.
GetLessOrEqual
Returns the last record in the current index path containing a value less than or equal to the value specified for the key fields
GetNext
Returns the next record in the current index path.
GetPrevious
Returns the previous record in the current index path
GetTotalSegments
Returns the total number of segments contained in the specified index of the file associated with the VAccess control.
IndexNumber
Returns the current index number for the table associated with the VAccess control.
Percentage
Sets the record to retrieve at the specified relative position along the currently selected index path in the associated table.
Position
Returns the value of the physical position of the current record in the table associated with the VAccess control.
RefreshLocations
Determines whether the VAccess control will use DDF files for metadata or whether it will use internal states and/or persisted properties for metadata.
StepFirst
Returns the first record in physical record storage order.
StepLast
Returns the last record in physical record storage order.
StepNext
Returns the next record in physical record storage order.
StepPrevious
Returns the previous record in physical record storage order.
Events
Table 30
Events for Retrieving Individual Records
Property or Method
Description
Validate
Fires before any record operation takes place on the associated table.