Author: Tomas Rutkauskas

When I have deleted an in-memory table and I want to create it again, I get an 
error message that I have duplicate field names. What is wrong here?

Answer:

This automatically creates and destroys memory tables as needed. Use these 
procedures to open and close your tables.

1   procedure OpenTbl(Tbl: TDBISAMTable);
2   begin
3     if (Tbl.Active = False) then
4     begin
5       with Tbl do
6       begin
7         try
8           if not (Exists) and InMemory then
9             CreateTable;
10          Open;
11          First;
12        except
13          raise EOpenTable.Create('Error: couldn' t open table.('+Tbl.TableName+':
14            '+Tbl.Name+')');

15    end;
16      end;
17    end;
18  end;
19  
20  procedure CloseTbl(Tbl: TDBISAMTable);
21  begin
22    with Tbl do
23    begin
24      if (Active = True) then
25      begin
26        if (state = dsInsert) or (state = dsEdit) then
27        begin
28          try
29            Post;
30          except
31            Cancel;
32          end;
33        end;
34        Tbl.FlushBuffers;
35        Close;
36        if InMemory then
37        begin
38          try
39            DeleteTable;
40          except
41            { ... }
42          end;
43        end;
44      end;
45    end;
46  end;