Please visit our sponsors !
The Open Method
The Open method opens an existing Record object or creates a new file or
directory.
Syntax
Open(source,actconn,mode,createopt,opt,username,psword)
|
| Parameter |
Description |
| source |
Optional. The source parameter may be one of the following:
- An absolute url
- A relative url
- An open Recordset
- Another Record object
- A Command object
- An SQL SELECT statement
- A table name
|
| actconn |
Optional. A connection string or a Connection object
|
| mode |
Optional. A ConnectModeEnum
value, that indicates the access mode of the Record object. Default is adModeUnknown
|
| createopt |
Optional. A RecordCreateOptionsEnum value, that
indicates whether an existing file/directory should be opened, or a new file/directory should be created.
Default is adFailIfNotExists. This parameter will be ignored if the source parameter
is not a URL
|
| opt |
Optional. One or more RecordOpenOptionsEnum
values, that specifies the options for opening the Record.
Default is adOpenRecordUnspecified
|
| username |
Optional. A user ID that authorizes access to source
|
| psword |
Optional. A password that verifies the username
|
Example
|
Example 1: source as the URL of a folder:
set rec = Server.CreateObject("ADODB.record")
rec.Open("http://www.w3schools.com/ado/")
Example 2: source as a relative URL in a Connection object:
set conn=Server.CreateObject("ADODB.Connection")
set rec = Server.CreateObject("ADODB.record")
conn.Open "URL=http://www.w3schools.com/ado/"
rec.Open("test.doc", conn)
Example 3: source as a row in a Recordset object:
set rs = Server.CreateObject("ADODB.recordset")
set rec = Server.CreateObject("ADODB.record")
rs.Open "test.doc", "URL=http://www.w3schools.com/ado/",,,adCmdTableDirect
rs.MoveLast()
rec.Open(rs)
|
ConnectModeEnum Values
| Constant |
Value |
Description |
| adModeUnknown |
0 |
Default. Permissions have not been set or cannot be
determined |
| adModeRead |
1 |
Read-only |
| adModeWrite |
2 |
Write-only |
| adModeReadWrite |
3 |
Read/write |
| adModeShareDenyRead |
4 |
Prevents others from opening a connection with read
permissions |
| adModeShareDenyWrite |
8 |
Prevents others from opening a connection with write
permissions |
| adModeShareExclusive |
12 |
Prevents others from opening a connection |
| adModeShareDenyNone |
16 |
Allows others to open a connection with any permissions |
| adModeRecursive |
0x400000 |
Used with adModeShareDenyNone, adModeShareDenyWrite, or
adModeShareDenyRead to set permissions on all sub-records of the current
Record |
RecordCreateOptionsEnum Values
| Constant |
Value |
Description |
| adFailIfNotExists |
-1 |
Default. Fails if the source parameter points
to a node that not exists |
| adCreateNonCollection |
0 |
Creates a new Record of type adSimpleRecord |
| adCreateCollection |
0x2000 |
Creates a new Record specified by the
source parameter. If it points to an existing node, an error
will occur. To prevent the error combine this value with adOpenIfExists or
adCreateOverwrite |
| adOpenIfExists |
0x2000000 |
If the source points to an existing
node or Record object, then the provider
must open the existing Record instead of creating a new one. This value cannot be used
with adCreateOverwrite |
| adCreateOverwrite |
0x4000000 |
If the source points to an existing
node or Record, then the existing Record will be overwritten
and a new one is created in its place. This value cannot be used with adOpenIfExists |
| adCreateStructDoc |
0x80000000 |
Creates a new Record of type adStructDoc |
RecordOpenOptionsEnum Values
| Constant |
Value |
Description |
| adOpenRecordUnspecified |
-1 |
Default. No options are specified |
| adOpenAsync |
0x1000 |
Opens the Record object in asynchronous mode |
| adDelayFetchStream |
0x4000 |
The default stream
associated with the Record need not be retrieved initially |
| adDelayFetchFields |
0x8000 |
The fields associated
with the Record need not be retrieved initially, but can be
retrieved at the first attempt to access the field |
| adOpenExecuteCommand |
0x10000 |
The source contains command text
that should be executed |
| adOpenOutput |
0x800000 |
If the source points to a node that
contains an executable script, then the opened Record
will contain the results of the executed script. This value is only
valid with non-collection records |
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
|
