📄 in_memorytables.htm

📁 Absolute Database 5.12 src. Absolute Database lets you forget the Borland Database Engine (BDE). Th
💻 HTM
字号:
<html>
<head>
   <title>In-Memory Tables</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>In-Memory Tables
<br>
</b></span>
    </td>
    <td align="right">
     <font face="Arial" size="2">
     <a href="importingandexportingrecord.htm">Previous</a>&nbsp;
     <a href="overview.htm">Top</a>&nbsp;
     <a href="encryptingdatabases.htm">Next</a>
     </font>
    </td>
  </tr>
</table>
<br><br>



<span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">
<br>
Absolute Database supports in-memory tables via TABSTable and TABSQuery components.
<br>
In-memory tables could be handled the same way as a disk tables with only few differences.
<br>

<br>
<b>Setting Component Properties</b>
<br>
<span style="font-family:Helvetica,Arial; font-size:4pt; color:#000000">
<br>
</span><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">The <a href=tabstable_inmemory.htm>InMemory</a> property of TABSTable or TABSQuery component should be set to True in order to handle in-memory table. Then the <i>DatabaseName</i> property is automatically set to the special in-memory database name "Memory".  In-memory tables are shared within the application, so you should set unique table name for each new in-memory table.
<br>

<br>

<br>
<b>Creating New In-Memory Table</b>
<br>
</span><span style="font-family:Helvetica,Arial; font-size:4pt; color:#000000">
<br>
</span><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">Before you can open in-memory table, you must create it by the call to <a href=tabstable_createtable.htm>CreateTable</a> method of TABSTable or by executing the CREATE TABLE SQL query.
<br>

<br>

<br>
<b>Creating an In-Memory Copy of Disk Table</b>
<br>
</span><span style="font-family:Helvetica,Arial; font-size:4pt; color:#000000">
<br>
</span><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">To create in-memory copy of the disk table, use the <a href=tabstable_copytable.htm>CopyTable</a> method of TABSTable component with 'MEMORY' value of the <i>DatabaseFileName</i> parameter: 
<br>

<br>
<table width="100%" border="0" cellpadding="0" cellspacing="0"><tr valign="top"><td width="14"></td><td><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"></span></span><span style="font-family:Courier New; font-size:8pt; color:#000000">ABSDiskTable.CopyTable(ABSInMemoryTable.TableName,&nbsp;<span style="font-family:Courier New; font-size:8pt; color:#000080">'MEMORY'</span></span><span style="font-family:Courier New; font-size:8pt; color:#000000">);
&nbsp;<br>
</span></td></tr></table><table width="100%" border="0" cellpadding="0" cellspacing="0"><tr valign="top"><td width="14"></td><td><span style="font-family:Courier New; font-size:8pt; color:#000000"></span></td></tr></table><span style="font-family:Courier New; font-size:8pt; color:#000000"></span><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">
<br>

<br>
<b>Copying an In-Memory Table to Disk Table</b>
<br>
</span><span style="font-family:Helvetica,Arial; font-size:4pt; color:#000000">
<br>
</span><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">To copy in-memory table to the disk table, use the <a href=tabstable_copytable.htm>CopyTable</a> method of TABSTable component with 'MEMORY' value of the <i>DatabaseFileName</i> parameter: 
<br>

<br>
<table width="100%" border="0" cellpadding="0" cellspacing="0"><tr valign="top"><td width="14"></td><td><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"></span></span><span style="font-family:Courier New; font-size:8pt; color:#000000">ABSInMemoryTable.CopyTable(ABSDiskTable.TableName,&nbsp;ABSDatabase1.DatabaseFileName);</span><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">
&nbsp;<br>
</span></td></tr></table><table width="100%" border="0" cellpadding="0" cellspacing="0"><tr valign="top"><td width="14"></td><td><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000"></span></td></tr></table><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">
<br>

<br>
<b>Deleting In-Memory Table</b>
<br>
</span><span style="font-family:Helvetica,Arial; font-size:4pt; color:#000000">
<br>
</span><span style="font-family:Helvetica,Arial; font-size:10pt; color:#000000">If in-memory table is no longer needed, you should delete it by the call to <a href=tabstable_deletetable.htm>DeleteTable</a> method of TABSTable or by executing DROP TABLE SQL query. All in-memory table not deleted till the apllication closing, are deleted by the Absolute DB Engine automatically.
<br>

<br>

<br>
</span></span>

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

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