📄 sortingrecordswithindexes.htm

📁 Absolute Database 5.12 src. Absolute Database lets you forget the Borland Database Engine (BDE). Th
💻 HTM
字号:
<html>
<head>
   <title>Sorting Records with Indexes</title>
</head>

<!--#include virtual="/inc/header.php"-->


<table width="100%" border="0" cellspacing="0" cellpadding="2" bgcolor="#FFFFFF">
  <tr>
    <td align="left">
      
<span style="font-family:Helvetica,Arial; font-size:12pt; color:#000000"><b>Sorting Records with Indexes
<br>
</b></span>
    </td>
    <td align="right">
     <font face="Arial" size="2">
     <a href="deletingrecords.htm">Previous</a>&nbsp;
     <a href="overview.htm">Top</a>&nbsp;
     <a href="lockingandmulti_useraccess.htm">Next</a>
     </font>
    </td>
  </tr>
</table>
<br><br>



<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">
<br>
An index determines the display order of records in a table. Typically, records appear in physical order. This default behavior does not require application intervention. If you want a different sort order, however, you must specify either
<br>

<br>
<table width="100%" border="0" cellpadding="0" cellspacing="0"><tr valign="top"><td width="14"><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"><font face="Symbol" size="2" color="#000000">&#183;</font></span></td><td><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">An alternate index for TABSTable component via <a href=tabstable_indexname.htm>IndexName</a> or <a href=tabstable_indexfieldnames.htm>IndexFieldNames</a> property.
&nbsp;<br>
</span></td></tr></table><table width="100%" border="0" cellpadding="0" cellspacing="0"><tr valign="top"><td width="14"><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"><font face="Symbol" size="2" color="#000000">&#183;</font></span></td><td><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">A list of columns on which to sort with TABSQuery component via ORDER BY clause.
&nbsp;<br>
</span></td></tr></table><table width="100%" border="0" cellpadding="0" cellspacing="0"><tr valign="top"><td><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"></span></td><td></td></tr></table><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">
<br>
An index could be created by <a href=tabstable_addindex.htm>AddIndex</a> method of TABSTable component.
<br>

<br>
<b>Examples:</b>
<br>

<br>
</span><span style="font-family:Courier New; font-size:8pt; color:#000000">ABSTable1.IndexName&nbsp;:=&nbsp;<span style="font-family:Courier New; font-size:8pt; color:#000080">'idxPrimary'</span></span><span style="font-family:Courier New; font-size:8pt; color:#000000">;
<br>

<br>
ABSTable1.IndexFieldNames&nbsp;:=&nbsp;<span style="font-family:Courier New; font-size:8pt; color:#000080">'LastName;FirstName'</span></span><span style="font-family:Courier New; font-size:8pt; color:#000000">;
<br>

<br>
ABSQuery1.SQL.Test&nbsp;:=&nbsp;'SELECT&nbsp;*&nbsp;FROM&nbsp;employee&nbsp;ORDER&nbsp;BY&nbsp;FirstName';
<br>
</span></span>

<!--#include virtual="/inc/footer.php"--> 
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -