ADO WillMove en MoveComplete Events
❮ Voltooi rekordstel-objekverwysing
Die WillMove-geleentheid
Die WillMove-gebeurtenis word geaktiveer voordat 'n bewerking die huidige posisie in die Rekordstel verander.
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 MoveComplete-gebeurtenis
Die MoveComplete-gebeurtenis word geaktiveer nadat die huidige posisie in die Rekordstel verander het.
Let wel: Voordat hierdie gebeurtenis terugkeer, stel die statusparameter op adStatusUnwantedEvent om daaropvolgende kennisgewings te voorkom.
Let wel: Die WillMove-gebeurtenis of MoveComplete-gebeurtenis kan voorkom wanneer een van die volgende Recordset-metodes gebel word: Open, Move, MoveFirst, MoveLast, MoveNext, MovePrevious, AddNew, en Requery. Hierdie gebeurtenisse kan ook voorkom as gevolg van die volgende eienskappe: Filter, Index, Bookmark, AbsolutePage en AbsolutePosition.
Sintaksis
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 |
EventReasonEnum-waardes
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 |
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