Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 6 of 6 total
Thread Steps to clear fields on memory table
Mon, Sep 11 2006 8:46 PMPermanent Link

"Jerry Hayes"
I've got a memory table that I'm planning on re-using as a general container
for different queries and different structures.

Is there anything appropriate to do to clear the existing information
besides:
    DBIsam.EmptyTable;
    DBIsam.FieldDefs.Clear;

Thanks all.

Mon, Sep 11 2006 9:43 PMPermanent Link

Jeff Cook
"Jerry Hayes" <jhayes@nospam-connexability-dot-com> wrote on Mon, 11 Sep 2006 20:42:12 -0400

>I've got a memory table that I'm planning on re-using as a general container
>for different queries and different structures.
>
>Is there anything appropriate to do to clear the existing information
>besides:
> DBIsam.EmptyTable;
> DBIsam.FieldDefs.Clear;
>
>Thanks all.
>
>
Jerry


If you are going to load it with SQL  e.g. SELECT * INTO "\memory\temp" FROM ...

then I don't think you even need to do the EmptyTable and Clear as the whole shebang will get over written.

Cheers


Jeff
--
Jeff Cook
Aspect Systems Ltd
Phone: +64-9-424 5388
Skype: jeffcooknz
www.aspect.co.nz



Mon, Sep 11 2006 9:57 PMPermanent Link

"Jerry Hayes"
> If you are going to load it with SQL e.g. SELECT * INTO "\memory\temp"
> FROM ...
>
> then I don't think you even need to do the EmptyTable and Clear as the
> whole shebang will get over written.

Thanks, Jeff.

I've got a middleware layer that's passing data, so it needs to be
recreated.

Tue, Sep 12 2006 4:09 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Jerry,

<< I've got a memory table that I'm planning on re-using as a general
container for different queries and different structures.

Is there anything appropriate to do to clear the existing information
besides:
    DBIsam.EmptyTable;
    DBIsam.FieldDefs.Clear; >>

Just clearing the fielddefs won't do what you want.  You must physically
overwrite the table with a new table structure by dropping it and then
re-creating it (DeleteTable,CreateTable).

--
Tim Young
Elevate Software
www.elevatesoft.com

Tue, Sep 12 2006 6:45 PMPermanent Link

"Jerry Hayes"
Tim,

Will DeleteTable accomplish everything by itself, or should I empty, clear
and then delete?

Wed, Sep 13 2006 9:01 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Jerry,

<< Will DeleteTable accomplish everything by itself, or should I empty,
clear and then delete? >>

Just DeleteTable will work.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image