Eventi ADO WillChangeRecordset e RecordsetChangeComplete


❮ Riferimento completo dell'oggetto Recordset

L'evento WillChangeRecordset

L'evento WillChangeRecordset viene attivato prima che un'operazione modifichi il recordset.

Nota: prima che questo evento si ripresenti, imposta il parametro status su adStatusCancel per annullare l'operazione che ha causato questo evento o impostalo su adStatusUnwantedEvent per evitare notifiche successive.

L'evento RecordsetChangeComplete

L'evento RecordsetChangeComplete viene attivato dopo la modifica di un Recordset.

Nota: prima che questo evento si ripresenti, imposta il parametro status su adStatusUnwantedEvent per evitare notifiche successive.

Nota: l'evento WillChangeRecordset e RecordsetChangeComplete può verificarsi quando si chiama il metodo Requery o il metodo Open di un oggetto Recordset.

Sintassi

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

EventReasonEnum valori

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

EventStatusEnum Valori

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

❮ Riferimento completo dell'oggetto Recordset