ADO Die WillChangeRecord- en RecordChangeComplete- gebeurtenisse
❮ Voltooi rekordstel-objekverwysing
Die WillChangeRecord-geleentheid
Die WillChangeRecord-gebeurtenis word geaktiveer voor een of meer rekordveranderings.
Let wel: Voordat hierdie gebeurtenis terugkeer, stel die statusparameter op adStatusCancel om die bewerking wat hierdie gebeurtenis veroorsaak het te kanselleer of stel dit op adStatusUnwantedEvent om daaropvolgende kennisgewings te voorkom.
Die RecordChangeComplete-gebeurtenis
Die RecordChangeComplete-gebeurtenis word geaktiveer nadat een of meer rekords verander is.
Let wel: Voordat hierdie metode terugkeer, stel die statusparameter op adStatusUnwantedEvent om daaropvolgende kennisgewings te voorkom.
Let wel: Die WillChangeRecord-gebeurtenis of die RecordChangeComplete-gebeurtenis kan voorkom as jy 'n veld in 'n rekord verander deur een van die volgende Recordset-bewerkings te gebruik: Update, Delete, CancelUpdate, AddNew, UpdateBatch en CancelBatch.
Sintaksis
WillChangeRecord reason,numrec,status,objRs
RecordChangeComplete reason,numrec,objErr,status,objRs
| Parameter | Description |
|---|---|
| reason | An EventReasonEnum value that specifies the reason for this event |
| numrec | Indicates the number of records affected |
| 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-waardes
| Constant | Value | Description |
|---|---|---|
| adRsnAddNew | 1 | An operation added a new record |
| adRsnDelete | 2 | An operation deleted a record |
| adRsnUpdate | 3 | An operation updated an existing record |
| adRsnUndoUpdate | 4 | An operation reversed the update of a record |
| adRsnUndoAddNew | 5 | An operation reversed the addition of a new record |
| adRsnUndoDelete | 6 | An operation reversed the deletion of a record |
| adRsnFirstChange | 11 | An operation made the first change to a record |
EventStatusEnum-waardes
| 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 |
❮ Voltooi rekordstel-objekverwysing