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 Us
Does 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
|