⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 createtableexample.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>Create Table Example
<br>
</b></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"> 
<br>
<span style="font-family:Courier New; font-size:8pt; color:#000000">&nbsp;&nbsp;<span style="font-family:Courier New; font-size:8pt; color:#000080"><i>{set&nbsp;up&nbsp;database&nbsp;component}</i></span></span><span style="font-family:Courier New; font-size:8pt; color:#000000">
<br>
&nbsp;&nbsp;ABSDatabase1.DatabaseName&nbsp;:=&nbsp;<span style="font-family:Courier New; font-size:8pt; color:#000080">'emp_db'</span></span><span style="font-family:Courier New; font-size:8pt; color:#000000">;
<br>
&nbsp;&nbsp;ABSDatabase1.DatabaseFileName&nbsp;:=&nbsp;<span style="font-family:Courier New; font-size:8pt; color:#000080">'c:\data\employee_db.abs'</span></span><span style="font-family:Courier New; font-size:8pt; color:#000000">;
<br>

<br>
&nbsp;&nbsp;<span style="font-family:Courier New; font-size:8pt; color:#000080"><i>{set&nbsp;up&nbsp;table&nbsp;component}</i></span></span><span style="font-family:Courier New; font-size:8pt; color:#000000">
<br>
&nbsp;&nbsp;ABSTable1.DatabaseName&nbsp;:=&nbsp;<span style="font-family:Courier New; font-size:8pt; color:#000080">'emp_db'</span></span><span style="font-family:Courier New; font-size:8pt; color:#000000">;
<br>
&nbsp;&nbsp;ABSTable1.TableName&nbsp;:=&nbsp;<span style="font-family:Courier New; font-size:8pt; color:#000080">'employee'</span></span><span style="font-family:Courier New; font-size:8pt; color:#000000">;
<br>
</span><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">
<br>
</span><span style="font-family:Courier New; font-size:8pt; color:#000000">&nbsp;&nbsp;<b>with</b>&nbsp;ABSTable1&nbsp;<b>do</b>
<br>
&nbsp;&nbsp;&nbsp;<b>begin</b>
<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Courier New; font-size:8pt; color:#000080"><i>{specifying&nbsp;table&nbsp;fields}</i></span></span><span style="font-family:Courier New; font-size:8pt; color:#000000">
<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<b>with</b>&nbsp;FieldDefs&nbsp;<b>do</b>
<br>
&nbsp;&nbsp;&nbsp;<b>begin</b>
<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Clear;
<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Add(<span style="font-family:Courier New; font-size:8pt; color:#000080">'EmpNo'</span></span><span style="font-family:Courier New; font-size:8pt; color:#000000">,ftAutoInc,<span style="font-family:Courier New; font-size:8pt; color:#000080">0</span></span><span style="font-family:Courier New; font-size:8pt; color:#000000">,False);
<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Add(<span style="font-family:Courier New; font-size:8pt; color:#000080">'LastName'</span></span><span style="font-family:Courier New; font-size:8pt; color:#000000">,ftString,2<span style="font-family:Courier New; font-size:8pt; color:#000080">0</span></span><span style="font-family:Courier New; font-size:8pt; color:#000000">,False);
<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Add(<span style="font-family:Courier New; font-size:8pt; color:#000080">'FirstName'</span></span><span style="font-family:Courier New; font-size:8pt; color:#000000">,ftString,15,False);
<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Add(<span style="font-family:Courier New; font-size:8pt; color:#000080">'PhoneExt'</span></span><span style="font-family:Courier New; font-size:8pt; color:#000000">,ftString,4,False);
<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Add(<span style="font-family:Courier New; font-size:8pt; color:#000080">'HireDate'</span></span><span style="font-family:Courier New; font-size:8pt; color:#000000">,ftDate,<span style="font-family:Courier New; font-size:8pt; color:#000080">0</span></span><span style="font-family:Courier New; font-size:8pt; color:#000000">,False);
<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Add(<span style="font-family:Courier New; font-size:8pt; color:#000080">'Salary'</span></span><span style="font-family:Courier New; font-size:8pt; color:#000000">,ftCurrency,<span style="font-family:Courier New; font-size:8pt; color:#000080">0</span></span><span style="font-family:Courier New; font-size:8pt; color:#000000">,False);
<br>
&nbsp;&nbsp;&nbsp;&nbsp;<b>end</b>;
<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span style="font-family:Courier New; font-size:8pt; color:#000080"><i>{specifying&nbsp;table&nbsp;indexes}</i></span></span><span style="font-family:Courier New; font-size:8pt; color:#000000">
<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<b>with</b>&nbsp;IndexDefs&nbsp;<b>do</b>
<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<b>begin</b>
<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Clear;
<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Add(<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">,<span style="font-family:Courier New; font-size:8pt; color:#000080">'EmpNo'</span></span><span style="font-family:Courier New; font-size:8pt; color:#000000">,[ixPrimary]);
<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Add(<span style="font-family:Courier New; font-size:8pt; color:#000080">'idxByLastNameFirstName'</span></span><span style="font-family:Courier New; font-size:8pt; color:#000000">,<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">,[ixCaseInsensitive]);
<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<b>end</b>;
<br>
&nbsp;&nbsp;&nbsp;<b>end</b>;
<br>

<br>
&nbsp;&nbsp;<span style="font-family:Courier New; font-size:8pt; color:#000080"><i>{create&nbsp;the&nbsp;database}</i></span></span><span style="font-family:Courier New; font-size:8pt; color:#000000">
<br>
&nbsp;&nbsp;<b>with</b>&nbsp;ABSDatabase1&nbsp;<b>do</b>
<br>
&nbsp;&nbsp;&nbsp;<span style="font-family:Courier New; font-size:8pt; color:#000080"><i>{if&nbsp;database&nbsp;file&nbsp;doesn't&nbsp;exist}</i></span></span><span style="font-family:Courier New; font-size:8pt; color:#000000">
<br>
&nbsp;&nbsp;&nbsp;&nbsp;<b>if</b>&nbsp;<b>not</b>&nbsp;Exists&nbsp;<b>then</b>
<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;CreateDatabase;
<br>

<br>
&nbsp;&nbsp;<span style="font-family:Courier New; font-size:8pt; color:#000080"><i>{and&nbsp;create&nbsp;the&nbsp;table}</i></span></span><span style="font-family:Courier New; font-size:8pt; color:#000000">
<br>
&nbsp;&nbsp;<b>with</b>&nbsp;ABSTable1&nbsp;<b>do</b>
<br>
&nbsp;&nbsp;&nbsp;<span style="font-family:Courier New; font-size:8pt; color:#000080"><i>{if&nbsp;table&nbsp;doesn't&nbsp;exist}</i></span></span><span style="font-family:Courier New; font-size:8pt; color:#000000">
<br>
&nbsp;&nbsp;&nbsp;&nbsp;<b>if</b>&nbsp;<b>not</b>&nbsp;Exists&nbsp;<b>then</b>
<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;CreateTable;
<br>

<br>
</span></span>

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

⌨️ 快捷键说明

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