FUDforum: comp.lang.php » deleted primary key can't be reused?

Home » Imported messages » comp.lang.php » deleted primary key can't be reused?

Show: Today's Messages :: Polls :: Message Navigator

Re: deleted primary key can't be reused? [message #181828 is a reply to message #181827]

Sat, 08 June 2013 14:57

richard

Messages: 213
Registered: June 2013

Karma:

Senior Member

On Sat, 8 Jun 2013 10:24:27 -0400, richard wrote:

> Entered 100 items into 2 columns each.
> Deleted 2.
> Upon entering new record using id of 98, no can do.
> The next new record number becomes 101.
> "Duplicate key error" is issued.
> How do I take back the deleted key number so I can use it again?
> No, I do not mean the data that is in the record.
> To me, once a record is deleted, the key index should reflect that the
> record no longer exists, so the key index should be -1 of what it was.
> Not continue its esistance.

well at least I got the keys back and reusable for now.

Report message to a moderator

[Message index]

		deleted primary key can't be reused? By: richard on Sat, 08 June 2013 14:24
		Re: deleted primary key can't be reused? By: richard on Sat, 08 June 2013 14:57
		Re: deleted primary key can't be reused? By: Luuk on Sat, 08 June 2013 15:46
		Re: deleted primary key can't be reused? By: The Natural Philosoph on Sat, 08 June 2013 17:47
		Re: deleted primary key can't be reused? By: Norman Peelman on Sat, 08 June 2013 19:32
		Re: deleted primary key can't be reused? By: gordonb.ps993 on Wed, 12 June 2013 04:46
		Re: deleted primary key can't be reused? By: Denis McMahon on Wed, 12 June 2013 05:52
		Re: deleted primary key can't be reused? By: Doug Miller on Wed, 12 June 2013 11:05
		Re: deleted primary key can't be reused? By: GravyCode on Fri, 21 June 2013 17:25
		Re: deleted primary key can't be reused? By: gordonb.tuxls on Sun, 23 June 2013 09:05
		Re: deleted primary key can't be reused? By: The Natural Philosoph on Sun, 23 June 2013 11:05
		Re: deleted primary key can't be reused? By: Marc van Lieshout on Fri, 21 June 2013 17:52

Previous Topic:	Read info from webcam video
Next Topic:	PHP form generator

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 30 20:15:19 GMT 2024

Total time taken to generate the page: 0.03898 seconds