📄 tabsadvindexdef_caseinsfields.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>TABSAdvIndexDef.CaseInsFields
<br>
</b><span style="font-family:Helv; font-size:9pt; color:#000000"><span style="font-family:Helv; font-size:9pt; color:#7F0000"><a href=tabsadvindexdef.htm>TABSAdvIndexDef</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">Specifies which fields of the index are case-insensitive.
<br>

<br>
<b>property</b> CaseInsFields: <b>String</b>;
<br>

<br>
<b>Description</b>
<br>
Set CaseInsFields to a string that lists the names of fields in the index, separated by semicolons. The ordering imposed by the index on the fields specified in CaseInsFields is case-insensitive. Fields in the index definition but not in the CaseInsFields list use case sensitive ordering (the default for the database type). It is possible that a single index can have fields using both case-insensitive and case-sensitive ordering.
<br>

<br>
For a field to be included in CaseInsFields, the field must be included in the fields on which the index is based. These fields are specified in the Fields property of the TABSAdvIndexDef object.
<br>

<br>
In the example below, the CaseInsFields property is given a list of two table fields for the index being created: LastName and Company. 
<br>

<br>
<span style="font-family:Courier New; font-size:8pt; color:#000000"><b>with</b>&nbsp;ABSTable1&nbsp;<b>do</b>&nbsp;<b>begin</b>
<br>
&nbsp;&nbsp;...
<br>
&nbsp;&nbsp;<b>with</b>&nbsp;AdvIndexDefs&nbsp;<b>do</b>&nbsp;<b>begin</b>
<br>
&nbsp;&nbsp;&nbsp;&nbsp;<b>with</b>&nbsp;AddIndexDef&nbsp;<b>do</b>&nbsp;<b>begin</b>
<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<b>Name</b>&nbsp;:=&nbsp;<span style="font-family:Courier New; font-size:8pt; color:#000080">'MultiIndex'</span></span><span style="font-family:Courier New; font-size:8pt; color:#000000">
<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Fields&nbsp;:=&nbsp;<span style="font-family:Courier New; font-size:8pt; color:#000080">'LastName;Company;State'</span></span><span style="font-family:Courier New; font-size:8pt; color:#000000">
<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Options&nbsp;:=&nbsp;[ixUnique];
<br>
&nbsp;&nbsp;&nbsp;&nbsp;<b>end</b>;
<br>
&nbsp;&nbsp;&nbsp;&nbsp;Items[IndexDefs.Count&nbsp;-&nbsp;<span style="font-family:Courier New; font-size:8pt; color:#000080">1</span></span><span style="font-family:Courier New; font-size:8pt; color:#000000">].CaseInsFields&nbsp;:=&nbsp;<span style="font-family:Courier New; font-size:8pt; color:#000080">'LastName;Company'</span></span><span style="font-family:Courier New; font-size:8pt; color:#000000">;
<br>
&nbsp;&nbsp;<b>end</b>;
<br>
&nbsp;&nbsp;...
<br>
&nbsp;&nbsp;CreateTable;
<br>
<b>end</b>;</span><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">
<br>

<br>
</span></span>

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

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