Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General Discussion » View Thread |
Messages 1 to 6 of 6 total |
Steps to clear fields on memory table |
Mon, Sep 11 2006 8:46 PM | Permanent 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 PM | Permanent 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 PM | Permanent 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 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 PM | Permanent Link |
"Jerry Hayes" | Tim,
Will DeleteTable accomplish everything by itself, or should I empty, clear and then delete? |
Wed, Sep 13 2006 9:01 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 |
This web page was last updated on Thursday, March 28, 2024 at 08:36 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |