Eventos ADO WillChangeRecordset y RecordsetChangeComplete
❮ Referencia completa de objetos de conjunto de registros
El evento WillChangeRecordset
El evento WillChangeRecordset se activa antes de que una operación cambie 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 RecordsetChangeComplete
El evento RecordsetChangeComplete se activa después de que un conjunto de registros haya cambiado.
Nota: antes de que vuelva este evento, establezca el parámetro de estado en adStatusUnwantedEvent para evitar notificaciones posteriores.
Nota: Los eventos WillChangeRecordset y RecordsetChangeComplete pueden ocurrir cuando se llama al método Requery o al método Open de un objeto Recordset.
Sintaxis
WillChangeRecord reason,status,objRs
RecordsetChangeComplete 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 |
adRsnResynch | 8 | An operation resynchronized the Recordset with the database |
adRsnClose | 9 | An operation closed 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