Roy, see my comments below. Is I right?

Robert

"Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message
news:92A77DCC-5479-4C63-8413-1585FD1C1B80@news.elevatesoft.com...
>
> procedure ZapInMemoryTable(WhichTable: TDBISAMTable);
> begin
> try
> if Assigned(WhichTable) and WhichTable.Exists then begin
> WhichTable.DisableControls;  // not needed
> WhichTable.Close;
> WhichTable.Exclusive := True; // not needed
> if not (WhichTable.Bof and WhichTable.Eof) then WhichTable.EmptyTable; //
> not needed
> WhichTable.DeleteTable;
> FreeAndNil(WhichTable);
> end;
> except
> end;
> end;

"Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message
news:92A77DCC-5479-4C63-8413-1585FD1C1B80@news.elevatesoft.com...
>
> You are doing it correctly to remove the memory table, however, I'd ditch
> the .Prepare.

In fact, some programmers *always* use an explicit prepare, which is a
mistake. Explicit prepare should ONLY be used on queries that are expected
to be executed more than once. Using prepare on other circumstances
needlessly leaves datasets assigned to the query.

Robert.

Roy,
Thanks for the advise and sample code...
Since the numeric tables do get created, can I control which folder they go into?

Thanks again,
Bryan

Roy Lambert <roy.lambert@skynet.co.uk> wrote:

Bryan


Just to expand on what Robert said.

The numeric named tables are DBISAM's temporary tables created when you run a query resulting in a canned dataset. These are cleaned up whenever the query is closed. If you find them on your disk after closing an app (or
the IDE) its because the system didn't shut down correctly.

Thanks for your suggestions Robert.
DBISAM support is outstanding!!!!

Bryan

"Robert" <ngsemail2005withoutthis@yahoo.com.ar> wrote:


"Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message
news:92A77DCC-5479-4C63-8413-1585FD1C1B80@news.elevatesoft.com...
>
> You are doing it correctly to remove the memory table, however, I'd ditch
> the .Prepare.

In fact, some programmers *always* use an explicit prepare, which is a
mistake. Explicit prepare should ONLY be used on queries that are expected
to be executed more than once. Using prepare on other circumstances
needlessly leaves datasets assigned to the query.

Robert.

Bryan,

<< Since the numeric tables do get created, can I control which folder they
go into? >>

The TDBISAMSession.PrivateDirectory controls this:

http://www.elevatesoft.com/dbisam4d7_starting_sessions.htm

(see at the bottom).

--
Tim Young
Elevate Software
www.elevatesoft.com

Robert


Pretty much correct as far as my understanding goes.

Roy Lambert