Eventos ADO WillMove y MoveComplete
❮ Referencia completa de objetos de conjunto de registros
El evento WillMove
El evento WillMove se activa antes de que una operación cambie la posición actual en el conjunto de registros.
Nota: Antes de que vuelva este evento, establezca el parámetro de estado en adStatusCancel para cancelar la operación que provocó este evento o configúrelo en adStatusUnwantedEvent para evitar notificaciones posteriores.
El evento MoveComplete
El evento MoveComplete se desencadena después de que haya cambiado la posición actual en el conjunto de registros.
Nota: antes de que vuelva este evento, establezca el parámetro de estado en adStatusUnwantedEvent para evitar notificaciones posteriores.
Nota: El evento WillMove o MoveComplete puede ocurrir cuando se llama a uno de los siguientes métodos Recordset: Open, Move, MoveFirst, MoveLast, MoveNext, MovePrevious, AddNew y Requery. Estos eventos también pueden ocurrir debido a las siguientes propiedades: Filter, Index, Bookmark, AbsolutePage y AbsolutePosition.
Sintaxis
WillMove reason,status,objRs
MoveComplete reason,objErr,status,objRs
Parameter | Description |
---|---|
reason | An EventReasonEnum value that specifies the reason for this event |
status | An EventStatusEnum value that indicates the status of the execution of the event |
objErr | The name of an Error object that describes the error if status is set to adStatusErrorsOccurred, otherwise it is not set |
objRs | The name of the Recordset object that triggered this event |
Valores de EventReasonEnum
Constant | Value | Description |
---|---|---|
adRsnRequery | 7 | An operation requeried the Recordset |
adRsnMove | 10 | An operation moved the record pointer within the Recordset |
adRsnMoveFirst | 12 | An operation moved the record pointer to the first record in the Recordset |
adRsnMoveNext | 13 | An operation moved the record pointer to the next record in the Recordset |
adRsnMovePrevious | 14 | An operation moved the record pointer to the previous record in the Recordset |
adRsnMoveLast | 15 | An operation moved the record pointer to the last record in the Recordset |
Valores de EventStatusEnum
Constant | Value | Description |
---|---|---|
adStatusOK | 1 | The operation that caused the event was successful |
adStatusErrorsOccurred | 2 | The operation that caused the event failed |
adStatusCantDeny | 3 | The operation that caused the event cannot be cancelled |
adStatusCancel | 4 | The operation that caused the event is cancelled |
adStatusUnwantedEvent | 5 | Prevents subsequent notifications before the event method has finished executing |
❮ Referencia completa de objetos de conjunto de registros