Retrieving Individual Records

This section lists the properties, methods, and events which you can use to retrieve individual records.

Properties and Methods

Table 5-8 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 5-9 Events for Retrieving Individual Records
Property or Method	Description
Validate	Fires before any record operation takes place on the associated table.