📄 tabstable_addindex.htm

📁 Absolute Database 5.12 src. Absolute Database lets you forget the Borland Database Engine (BDE). Th
💻 HTM
字号:
<html>
<head>
   <title></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>TABSTable.AddIndex</b><span style="font-family:Helvetica,Arial; font-size:12pt; color:#0000FF"><b>
<br>
</b></span><span style="font-family:Helv; font-size:9pt; color:#000000"><span style="font-family:Helv; font-size:9pt; color:#7F0000"><a href=tabstable.htm>TABSTable</a></span></span><span style="font-family:Helvetica,Arial; font-size:12pt; color:#000000"><b>
<br>
</b></span></span>
    </td>
    <td align="right">
     <font face="Arial" size="2">
     
     <a href="overview.htm">Top</a>&nbsp;
     
     </font>
    </td>
  </tr>
</table>
<br><br>



<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Creates a new index for the table.
<br>

<br>
<b>procedure</b> AddIndex(<b>const</b> Name, Fields: String; Options: <a href=tindexoptions_type.htm>TIndexOptions</a>;<b>const</b> DescFields: String=''; <b>const</b> CaseInsFields: String='');
<br>

<br>
<b>Description</b>
<br>
Call AddIndex to create a new index for an<span style="font-family:Helvetica,Arial; font-size:10pt; color:#0000FF"> </span><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">existing table associated with a dataset component. The index created with this procedure is added to the database table corresponding to the dataset component.
<br>

<br>
Name is the name of a new index.
<br>

<br>
Fields is a String value containing the field or fields which are used to serve as a base for<span style="font-family:Helvetica,Arial; font-size:10pt; color:#0000FF"> </span></span><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">the new index. If more than one field is used, separate the field names in the list with semi-colons.
<br>

<br>
Options is a set of attributes for the index. The Options parameter may contain any, multiple, or none of the TIndexOptions constants: ixPrimary, ixDescending, and ixCaseInsensitive. See the topic for the TIndexOptions type for definitions of individual constants and for implications of using them.
<br>

<br>
DescFields is a string containing a list of field names, separated by semi-colons. DescFields specifies fields with descending ordering for the new index. Fields in the index definition but not in the DescFields list use the default ascending ordering. It is possible that a single index can have fields using both ascending and descending ordering.
<br>

<br>
CaseInsFields is a string containing a list of field names, separated by semi-colons. CaseInsFields specifies case insensitive fields for the new index. Fields in the index definition but not in the CaseInsFields list use the default case sensivity option. It is possible that a single index can have fields using both case sensitive and case insensitive options.
<br>

<br>
ABSTable1.AddIndex('MostPaid', 'CustNo;SaleDate;AmountPaid', [ixCaseInsensitive], 'SaleDate;AmountPaid');
<br>

<br>
</span></span>

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

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