📄 ado_ref_record.asp@output=print
字号:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html lang="en-US" xml:lang="en-US" xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>ADO Record Object</title>
<link rel="shortcut icon" href="../favicon.ico" type="image/x-icon" />
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<meta name="Keywords" content="xml,tutorial,html,dhtml,css,xsl,xhtml,javascript,asp,ado,vbscript,dom,sql,colors,soap,php,authoring,programming,training,learning,beginner's guide,primer,lessons,school,howto,reference,examples,samples,source code,tags,demos,tips,links,FAQ,tag list,forms,frames,color table,w3c,cascading style sheets,active server pages,dynamic html,internet,database,development,Web building,Webmaster,html guide" />
<meta name="Description" content="Free HTML XHTML CSS JavaScript DHTML XML DOM XSL XSLT RSS AJAX ASP ADO PHP SQL tutorials, references, examples for web building." />
<meta http-equiv="pragma" content="no-cache" />
<meta http-equiv="cache-control" content="no-cache" />
<script type="text/javascript">
var gaJsHost = (("https:" == document.location.protocol) ? "../../https@ssl./default.htm" : "../../www./default.htm");
document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));
</script>
<script type="text/javascript">
var pageTracker = _gat._getTracker("UA-3855518-1");
pageTracker._initData();
pageTracker._trackPageview();
</script>
</head>
<body>
<p>From <b>http://www.w3schools.com</b> (Copyright Refsnes Data)</p>
<h1>ADO Record Object</h1>
<a href="ado_ref_property.asp"><img border="0" src="../images/btn_previous.gif" alt="prev" width="100" height="20" /></a>
<a href="ado_ref_recordset.asp"><img border="0" src="../images/btn_next.gif" alt="next" width="100" height="20" /></a>
<hr />
<h2>Record Object (ADO version 2.5)</h2>
<p>The ADO Record object is used to hold a row in a Recordset, a directory, or a
file from a file system.</p>
<p>Only structured databases could be accessed by ADO in versions prior 2.5. In
a structured database, each table has the exact same number of columns in each row, and each column is composed of the same data type.</p>
<p>The Record object allows access to data-sets where the number of columns and/or the data type can
be different from row to row. </p>
<h3>Syntax</h3>
<table class="ex" cellspacing="0" border="1" width="100%" cellpadding="3">
<tr valign="top">
<td valign="top">
<pre>objectname.property
objectname.method</pre>
</td>
</tr>
</table>
<h3>Properties</h3>
<table class="ex" cellspacing="0" border="1" width="100%" cellpadding="3">
<tr valign="top">
<th width="35%" align="left" valign="top">Property</th>
<th width="65%" align="left" valign="top">Description</th>
</tr>
<tr>
<td valign="top"><a href="prop_rec_activeconn.asp">ActiveConnection</a></td>
<td valign="top">Sets or returns which Connection object a Record object
belongs to</td>
</tr>
<tr valign="top">
<td valign="top"><a href="prop_rec_mode.asp">Mode</a></td>
<td valign="top">Sets or returns the permission for modifying data in a
Record object</td>
</tr>
<tr valign="top">
<td valign="top"><a href="prop_rec_parenturl.asp">ParentURL</a></td>
<td valign="top">Returns the absolute URL of the parent Record</td>
</tr>
<tr valign="top">
<td valign="top"><a href="prop_rec_recordtype.asp">RecordType</a></td>
<td valign="top">Returns the type of a Record object</td>
</tr>
<tr valign="top">
<td valign="top"><a href="prop_rec_source.asp">Source</a></td>
<td valign="top">Sets or returns the src parameter of the Open method of a Record
object</td>
</tr>
<tr valign="top">
<td valign="top"><a href="prop_rec_state.asp">State</a></td>
<td valign="top">Returns the status of a Record object</td>
</tr>
</table>
<h3>Methods</h3>
<table class="ex" cellspacing="0" border="1" width="100%" cellpadding="3">
<tr valign="top">
<th width="35%" align="left" valign="top">Method</th>
<th width="65%" align="left" valign="top">Description</th>
</tr>
<tr>
<td valign="top"><a href="met_rec_cancel.asp">Cancel</a></td>
<td valign="top">Cancels an execution of a CopyRecord, DeleteRecord,
MoveRecord, or Open call</td>
</tr>
<tr>
<td valign="top"><a href="met_rec_close.asp">Close</a></td>
<td valign="top">Closes a Record object</td>
</tr>
<tr>
<td valign="top"><a href="met_rec_copy_move_record.asp">CopyRecord</a></td>
<td valign="top">Copies a file or directory to another location</td>
</tr>
<tr>
<td valign="top"><a href="met_rec_deleterecord.asp">DeleteRecord</a></td>
<td valign="top">Deletes a file or directory</td>
</tr>
<tr>
<td valign="top"> <a href="met_rec_getchildren.asp"> GetChildren</a></td>
<td valign="top">Returns a Recordset object where each row represents the
files in the directory</td>
</tr>
<tr>
<td valign="top"><a href="met_rec_copy_move_record.asp">MoveRecord</a></td>
<td valign="top">Moves a file or a directory to another location</td>
</tr>
<tr>
<td valign="top"><a href="met_rec_open.asp">Open</a></td>
<td valign="top">Opens an existing Record object or creates a new file or
directory</td>
</tr>
</table>
<h3>Collections</h3>
<table class="ex" cellspacing="0" border="1" width="100%" cellpadding="3">
<tr valign="top">
<th width="35%" align="left" valign="top">Collection</th>
<th width="65%" align="left" valign="top">Description</th>
</tr>
<tr>
<td valign="top">Properties</td>
<td valign="top">A collection of provider-specific properties</td>
</tr>
<tr>
<td valign="top">Fields</td>
<td valign="top">Contains all the Field objects in the Record object</td>
</tr>
</table>
<h3>The Fields Collection's Properties</h3>
<table class="ex" cellspacing="0" border="1" width="100%" cellpadding="3">
<tr valign="top">
<th width="35%" align="left" valign="top">Property</th>
<th width="65%" align="left" valign="top">Description</th>
</tr>
<tr>
<td valign="top">Count</td>
<td valign="top">Returns the number of items in the fields collection.
Starts at zero.
<p>Example:</p>
<p><span class="CODE">countfields = rec.Fields.Count</span></p>
</td>
</tr>
<tr>
<td valign="top">Item(named_item/number)</td>
<td valign="top">Returns a specified item in the fields collection.
<p>Example:</p>
<p><span class="CODE">itemfields = rec.Fields.Item(1)<br />
or<br />
itemfields = rec.Fields.Item("Name")</span></p>
</td>
</tr>
</table>
<br />
<hr />
<a href="ado_ref_property.asp"><img border="0" src="../images/btn_previous.gif" alt="prev" width="100" height="20" /></a>
<a href="ado_ref_recordset.asp"><img border="0" src="../images/btn_next.gif" alt="next" width="100" height="20" /></a>
<p>From <b>http://www.w3schools.com</b> (Copyright Refsnes Data)</p>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -