Quick References
      ADO
      ASP
      CSS2
      HTML
      JavaScript
      Jet SQL
      VBScript
      WML
      WMLScript
      WSH
      XHTML
      XML DOM
      XSLT

Features
      Knowledge Base
      Tutorials

Partners
     ZVON.ORG
     XML
     Planet Source Code
     VisualBuilder
     Web Design
     Your HTML Source
     XML/XSLT Forums
     ASPAlliance
     Scripts
     
     Programmers Heaven
     Tek-Tips Forums
     Developer Fusion
     Code Project











METHOD:  DataControl::SubmitChanges
datacontrolobject.SubmitChanges

The SubmitChanges method is called to submit any pending changes to the data source of the Recordset.

The Recordset must be updateable. Also, the Connect, Server, and SQL properties must first be set. If the URL property is set, the pending changes will be sent to the specified location. If the pending changes have been filtered, only those pending changes that survived being filtered will be sent to the data source for updating.

Note that only the changes are submitted, not the entire Recordset. Every one of the changes must be successfully completed or the entire update attempt fails and none of the changes will be committed to the data source.

You can use buttons on a Web page to navigate and manipulate a displayed recordset. For example, when the appropriate button is clicked, you can call a subroutine containing either this method or the CancelUpdate method:

Code (VBScript):
Sub SubmitChange_OnClick
   objDataControl.SubmitChanges
   objDataControl.Refresh
End Sub

Sub CancelUpdate_OnClick
   objDataControl.CancelUpdate
   objDataControl.Refresh
End Sub

  


Copyright 1999-2005 by Infinite Software Solutions, Inc. All rights reserved.
Trademark Information