> > the table. This resets the AutoInc field to the last number
> +1, and should
> > allow posting to the table again.
>
> only if there's no foreign key in another table !!!!
Speaking of which, I had to do this a couple of months ago: convert a large
Delphi/Paradox app from using many autoinc fields (including FK's in other
tables), to using standard integer fields.
I found a freeware app which does this and preserves the existing autoinc
field values.
Steve.
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
