|   Please visit our sponsors !
 The Save Method  
 The Save method saves a Recordset object to a file or a Stream object. When
the save method is finished, the record pointer will point at the first record
of the Recordset.
             Note: If there is a filter applied to the Recordset, only the
"filtered" records will be saved. 
             Note: This method can only be called on an open Recordset.
             Syntax
             
              
                | objRecordset.Save destination,persistformat |  
  
              
                | Parameter | Description |  
                | destination | Optional. Specifies where to save the Recordset object;
      the
      path name of a file or a reference to a Stream object |  
                | persistformat | Optional. A 
      PersistFormatEnum value that specifies the format of the Recordset (XML or
      ADTG). Default is adPersistADTG |  Example 
              
                | You can save a Recordset in XML format:
                   <%
set xmlDoc=CreateObject("Microsoft.XMLDOM")
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "c:/webdata/northwind.mdb"set rs = Server.CreateObject("ADODB.recordset")
rs.Open "Customers", conn
'Save the Recordset into a DOM tree
rs.Save xmldoc, 1
%> |  
 
 PersistFormatEnum Values 
              
                | Constant | Value | Description |  
                | adPersistADTG | 0 | Saves in a Microsoft Advanced Data TableGram (ADTG) format. |  
                | adPersistXML | 1 | Saves in Extensible Markup Language (XML) format |  
                | adPersistADO | 1 | Saves in ADO's own Extensible Markup Language
          (XML) format. This value is the same as adPersistXML and
          is included for backwards compatibility |  
                | adPersistProviderSpecific | 2 | The provider will persist the Recordset
          using its own format |  
 
   
Jump to: Top of Page
or HOME or
             Printer friendly page 
 Search W3Schools:
 What Others Say About UsDoes the world know about us? Check out these places: 
            Dogpile
            Alta Vista
            MSN
            Google
            Excite
            Lycos
            Yahoo
            Ask Jeeves
             
 We Help You For Free. You Can Help Us!
 
W3Schools is for training only. We do not warrant its correctness or its fitness for use.
The risk of using it remains entirely with the user. While using this site, you agree to have read and accepted our
            terms of use and 
            privacy policy. 
            Copyright 1999-2002 by Refsnes Data. All Rights Reserved 
 |