> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of James Sugrue
> Sent: Tuesday, 17 July 2001 13:59
> To: Multiple recipients of list delphi
> Subject: RE: [DUG]: Key Violation
>
>
> Sounds like the problem was due to a system crash when the
> program was open.
> We get this quite a bit.
>
> One (ugly) fix is to change the AutoInc field to an Integer field and save
> the table. Then go back and change it back to an AutoInc and save and pack
> 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 !!!!
---------------------------------------------------------------------------
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/
