<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html><!-- InstanceBegin template="/templates/interface.dwt" codeOutsideHTMLIsLocked="false" -->
<head>
<!-- InstanceBeginEditable name="doctitle" -->
<title>Database Objects</title>
<!-- InstanceEndEditable -->
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<!-- InstanceBeginEditable name="head" --><!-- InstanceEndEditable --><!-- InstanceParam name="remarks2" type="boolean" value="false" -->
<link href="default.css" rel="stylesheet" type="text/css">
</head>
<body>
<h1>
<h1><!-- InstanceBeginEditable name="heading" -->IDatabaseObjects<!-- InstanceEndEditable --></h1>
<h3><!-- InstanceBeginEditable name="subheader" --> IDatabaseObjects_OrderBy <span class="keyword">As</span> SQLSelectOrderByFields<!-- InstanceEndEditable --><br>
</h3>
</h1>
<!-- InstanceBeginEditable name="text" -->
<p> This function should return an SQLSelectOrderByFields object containing the
list of fields
the
collection will be sorted by. Just as with an SQL statement, the order of the
fields added to the collection indicates the group sorting. If <a href="IDatabaseObjects_TableJoins.htm">IDatabaseObjects_TableJoins</a> has
been implemented then fields from the adjoining
table or tables can be utilized. The sort order is used by the <a href="DatabaseObjects_ObjectByOrdinal.htm">ObjectByOrdinal</a>,
<a href="DatabaseObjects_ObjectByOrdinalFirst.htm">ObjectByOrdinalFirst</a> and <a href="DatabaseObjects_ObjectsSearch.htm">ObjectsSearch</a> functions.
Implementing this function is optional.</p>
<!-- InstanceEndEditable -->
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td bgcolor="#EAEBFF"><font size="-1">This interface function/property is
utilised by the following functions:<br>
<b><!-- InstanceBeginEditable name="utilisedby" -->ObjectByOrdinal, ObjectByOrdinalFirst,
ObjectsCollection, ObjectsSearch<!-- InstanceEndEditable --></b></font></td>
</tr>
</table><br>
<font face="Courier New, Courier, mono">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td bgcolor="#f6f6f6"><pre><!-- InstanceBeginEditable name="example" --><span class="keyword">
Private Function</span> IDatabaseObjects_OrderBy() <span class="keyword">As</span> SQLSelectOrderByFields
<span class="comment">'Sort the products by th<font face="Courier New, Courier, mono">eir </font>product code<font face="Courier New, Courier, mono"></font></span><font face="Courier New, Courier, mono">
</font><span class="keyword">Set</span> IDatabaseObjects_OrderBy = <span class="keyword">New</span> SQLSelectOrderByFields<font face="Courier New, Courier, mono">
</font>IDatabaseObjects_OrderBy.Add "Product<font face="Courier New, Courier, mono">Code</font>", dboOrderAscending
<span class="keyword">End Function</span>
<!-- InstanceEndEditable --></pre></td>
</tr>
</table>
</font>
<p></p>
<!-- InstanceBeginEditable name="remarks" -->
<p> </p>
<!-- InstanceEndEditable -->
<p> </p>
<p align="center"><font size="1">� Hi Integrity Systems 2005. All rights reserved.</font></p>
</body>
<!-- InstanceEnd --></html>