Hello,

I need to restructure a dbisam table by code (with a TDBIsamTable),
because when I empty a table an autoincfield doesn't restart at zero.

it seems that restructure method need a lot of parameters, can you help
me a little?

I don't need to modify the structure, only restructuring for making the
autoinc field starting again at zero...

Thanks

John

Hey John,

try SQL:

ALTER TABLE [Tablename] LAST AUTOINC 0

I love it

Ralf


"John" <noSpam@noSpam.com> schrieb im Newsbeitrag
news:6E81477E-3C56-4EC4-BC38-2C8478C2BECC@news.elevatesoft.com...
> Hello,
>
> I need to restructure a dbisam table by code (with a TDBIsamTable),
> because when I empty a table an autoincfield doesn't restart at zero.
>
> it seems that restructure method need a lot of parameters, can you help me
> a little?
>
> I don't need to modify the structure, only restructuring for making the
> autoinc field starting again at zero...

John,

<< it seems that restructure method need a lot of parameters, can you help
me a little? >>

Use this code:

with DBISAMTable do
    begin
    RestructureFieldDefs.Update;
    RestructureIndexDefs.Update;.
    RestructureTable(LanguageID,SortID,UserMajorVersion,UserMinorVersion,
                              Encrypted,Password,Description,BlobBlockSize,0,False);
    end;

--
Tim Young
Elevate Software
www.elevatesoft.com

Thanks Ralf and Tim