</ iframe > </noscript> <!-- End Google Tag Manager (noscript) --> <div id="BeforeHeaderContent"> </div> <div id="HeaderContent"> <div id="ProjectTitle">ComponentOne True DataControl 8.0</div> <div id="PageTitle"><div id="PageTitleText">RecordsetChangeComplete Event</div></div> </div> <div id="AfterHeaderContent"> <!-- Spacing --> <span id="ToggleAllSectionsLink" class="FunctionLink"> <label id="CollapseAllLabel">Collapse All</label> <label id="ExpandAllLabel" style="display: none;">Expand All</label> </span> </div> <div class="BreadcrumbsContainer"><table><tr><td> <a href="truedatacontrol80reference.html">True DataControl 8.0 Reference</a> > <a href="truedatacontrolcontrol.html">True DataControl Control</a> > <a href="tdatacontrolevents1.html">TData Control Events</a> > RecordsetChangeComplete Event</td></tr></table></div> <div id="BodyContent"> <script language="javascript" type="text/javascript"> //<![CDATA[ <!-- if (typeof d2hInitMainThemeHandlers != "undefined") d2hInitMainThemeHandlers(); //--> //]]> </script> <div id="nsbanner"> <div id="TitleRow"> <div id="ienav"> <p align="left"><a id="D2HPrevious" href="recordchangecompleteevent.html"></a> <a id="D2HNext" href="useradddataevent.html"></a></p> </div> </div> </div> <div id="nstext" valign="bottom" hasuserbackground="true"> <div id="d2h_breadcrumbs"> <a href="truedatacontrol80reference.html">True DataControl 8.0 Reference</a>> <a href="truedatacontrolcontrol.html">True DataControl Control</a>> <a href="tdatacontrolevents1.html">TData Control Events</a>> RecordsetChangeComplete Event </div> <p>RecordsetChangeComplete Event</p> <p>Occurs after the whole recordset has changed.</p> <h3>Syntax</h3> <p>TData_<strong>RecordsetChangeComplete</strong> (ByVal adReason As EventReasonEnum, ByVal pError As ADODB.Error, adStatus As EventStatusEnum)</p> <h3>Remarks</h3> <p>Arguments: <i>adReason</i> is an ADO EventReasonEnum value. Specifies the reason for this event. Its value can beadRsnReQuery, adRsnReSynch, adRsnClose, adRsnOpen.</p> <p>pError is an ADO <strong>Error</strong> object. It describes the error that occurred if the value of adStatus is adStatusErrorsOccurred; otherwise it is not set.</p> <p>adStatus is an ADO EventStatusEnum status variable. When <strong>RecordsetChangeComplete</strong> is called, this parameter is set toadStatusOK if the operation that caused the event was successful, adStatusErrorsOccurred if the operation failed, or adStatusCancel if the operation associated with the previously accepted <strong>WillChangeRecordset</strong> event has been canceled.</p> <p>The <strong>RecordsetChangeComplete</strong> event is a standard ADO Recordset event fired by the <a href="javascript:TL_714188.HHClick()">TData</a> control’s <a href="javascript:TL_714189.HHClick()">Recordset</a>. For more information, see <a href="JavaScript:TL_714190.HHClick()">Using recordset events</a>. As with any ADO recordset, this event occurs after the whole contents of the recordset change due to a pending operation. It is also fired when an operation has attempted to change the recordset, and failed. This case can be detected by the value of the adStatus argument, it is set to adStatusErrorsOccurred if the operation failed.</p> <p>The <strong>RecordsetChangeComplete</strong> event may occur due to the following <a href="javascript:TL_714191.HHClick()">Recordset</a> operations: <strong>Requery</strong>, <strong>Resync</strong>, <strong>Close</strong>, <strong>Open</strong>, and <strong>Filter</strong>.</p> <p>See Also</p> <p><a href="JavaScript:TL_714192.HHClick()">TData Control</a></p> </div> <a name="seealsobookmark"></a> </div> <div id="FooterContent"> <p> </p><p> </p><hr style="height: 1px"><p>Copyright (c) <script type="text/javascript"> var theDate=new Date() document.write(theDate.getFullYear()) </script> GrapeCity, inc. All rights reserved. <script> $(document).ready(function() { if (!(window.self !== window.top)) { // Not running in a frameset // Get the page name var pageName = location.href.substring(location.href.lastIndexOf("/") + 1); if (pageName.indexOf("#") != -1) { pageName = pageName.substring(0, pageName.indexOf("#")); } // Append to webframe.html var framePage = "webframe.html#" + pageName; location.href = framePage; } }); </script></p> <a target="_blank" href="http://our.componentone.com/groups/">Product Support Forum</a> | <a target="_blank" href="http://feedback.componentone.com/forums/255792-activex-documentation">Documentation Feedback</a> </div> </body> </html>