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

deleted primary key can't be reused? [message #181827]

Sat, 08 June 2013 14:24

richard

Messages: 213
Registered: June 2013

Karma:

Senior Member

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.

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: Wed Nov 27 21:51:41 GMT 2024

Total time taken to generate the page: 0.04257 seconds