W3Schools.com

ADO WillChangeField and FieldChangeComplete Events

Recordset Object Reference Complete Recordset Object Reference

The WillChangeField Event

The WillChangeField event is triggered before the values of one or more Field Objects are changing.

Note: Before this event returns, set the status parameter to adStatusCancel to cancel the operation that caused this event. 

The FieldChangeComplete Event

The FieldChangeComplete event is triggered after the values of one or more Field Objects have been changed.

Note: Before this event returns, set the status parameter to adStatusUnwantedEvent to prevent subsequent notifications. 

Note: The WillChangeField event and the FieldChangeComplete event may occur when you set the Value property and calls the Update method with field and value array parameters.

Syntax

WillChangeField numfields,fields,status,objRs

FieldChangeComplete numfields,fields,objErr,status,objRs 

Parameter Description
numfields The number of Field objects in fields
fields An array that contains Field objects with changes
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

EventStatusEnum Values
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

Recordset Object Reference Complete Recordset Object Reference
W3Schools Certification

W3Schools' Online Certification

The perfect solution for professionals who need to balance work, family, and career building.

More than 10 000 certificates already issued!

Get Your Certificate »

The HTML Certificate documents your knowledge of HTML.

The CSS Certificate documents your knowledge of advanced CSS.

The JavaScript Certificate documents your knowledge of JavaScript and HTML DOM.

The jQuery Certificate documents your knowledge of jQuery.

The XML Certificate documents your knowledge of XML, XML DOM and XSLT.

The ASP Certificate documents your knowledge of ASP, SQL, and ADO.

The PHP Certificate documents your knowledge of PHP and SQL (MySQL).

WEB HOSTING
Best Web Hosting
PHP MySQL Hosting
Best Hosting Coupons
UK Reseller Hosting
Cloud Hosting
Top Web Hosting
$7.95/mo SEO Hosting
Premium Website Design
WEB BUILDING
Download XML Editor
FREE Website BUILDER
Free Website Templates Free CSS Templates
Make Your Own Website
W3SCHOOLS EXAMS
Get Certified in:
HTML, CSS, JavaScript, XML, PHP, and ASP
W3SCHOOLS BOOKS
New Books:
HTML, CSS
JavaScript, and Ajax
STATISTICS
Browser Statistics
Browser OS
Browser Display
SHARE THIS PAGE