w3schools
Search W3Schools :  
  
HOME HTML CSS XML JAVASCRIPT ASP PHP SQL MORE...   References Examples Forum About

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

1,050,724 Sites built with Wix. Make your own!

Click here to design a Stunning Flash Website for Free

Wix is a revolutionary web design tool that provides anyone with the possibility to create professional and beautiful websites for free.

With e-commerce features, search engine visibility and many more professional tools, Wix is the ultimate solution for creating a spectacular site while saving tons of money.



FUNC Travel
WEB HOSTING
Best Web Hosting
PHP MySQL Hosting
Top 10 Web Hosting
UK Reseller Hosting
Web Hosting
FREE Web Hosting
Top Web Hosting
Windows Hosting
WEB BUILDING
Download XML editor
FREE Flash Website
FREE Web Templates
Website Monetization
FLIGHT TICKETS
Find the cheapest flight
to any destination now!
EDUCATION
US Web Design Schools
HTML Certification
JavaScript Certification
XML Certification
PHP Certification
ASP Certification
STATISTICS
Browser Statistics
Browser OS
Browser Display

W3Schools.com HOME | TOP | PRINT | FORUM | ABOUT
W3Schools is for training only. We do not warrant the correctness of its content. The risk from using it lies entirely with the user.
While using this site, you agree to have read and accepted our terms of use and privacy policy.
Copyright 1999-2009 by Refsnes Data. All Rights Reserved.