Re: I need to change the auto incrementation of an integer
From: Stephan Born <stephan.born_at_beusen.de>
Date: Thu, 04 Nov 1999 15:51:34 +0100
Message-ID: <38219D76.B2E1D828_at_beusen.de>
Date: Thu, 04 Nov 1999 15:51:34 +0100
Message-ID: <38219D76.B2E1D828_at_beusen.de>
> when I delete the table ... new records won't begin at zero.
> I need to reset the counter of this field !!
> THX
???
Some questions:
What do you mean with 'new records won't begin at zero'? Do you have a column <objectid> which does not start again at 0?
Where do you get this value from? Do you read this value from a sequence?
If it is so you have to reset this sequence, too.
Regards, Stephan
-- --------------------------------------------------------------- Dipl.-Inf. (FH) Stephan Born | beusen Consulting GmbH fon: +49 30 549932-0 | Landsberger Allee 392 fax: +49 30 549932-29 | 12681 Berlin mailto:stephan.born_at_beusen.de | Germany --------------------------------------------------------------- PGP-Key verfügbar | PGP-Key available ---------------------------------------------------------------Received on Thu Nov 04 1999 - 15:51:34 CET