PreviousActiveX Controls Guide (v10) Next

GetLast

Chapter contents

Applies to:

VAccess

Description

Attempts to retrieve the last record in the current index path and returns, as an Integer value, the Pervasive PSQL status code.

Syntax

object.GetLast [vLockBias] 
 

Part
Description
object
Required. The object placeholder represents an object expression that evaluates to an object in the Applies To list.
vLockBias
Optional. Value representing the type of record lock to place on the record when it is retrieved. Default is 0, no lock. One of the following constants:
Const BTO_SingleNoWait = 200
Const BTO_MultiNoWait = 400

Remarks

This method attempts to retrieve the last record in the currently selected index path, set through the IndexNumber property, from the file associated with object. The status code for the operation will be returned by the method and set in the Status property of the control, a value of zero indicating success. A Status Code 9 indicates that there are no records in the current index path.

Example

'Retrieve the record with the most recent date 
Customers.IndexNumber = 3    'entry date 
Customers.GetLast 

Chapter contents
Book contents

Prev topic: GetGreaterOrEqual
Next topic: GetLess