Unique db ID

Rails
1

Hi!

In my db i store things like articles… and they are given an id like
17 or somthing. When i then delete article 17 and create a new one that
one will have id 17, my question is: Is there a way to give that articel
id 18?

I use sqlite3.

Thanks

2

On Tue, Aug 26, 2008 at 5:20 AM, Mikael Björkegren
[email protected] wrote:

Hi!

In my db i store things like articles… and they are given an id like
17 or somthing. When i then delete article 17 and create a new one that
one will have id 17, my question is: Is there a way to give that articel
id 18?

I use sqlite3.

Assuming that you’re following conventions, sqlite should
automatically increment the id with each new record. Did you use
migrations to create the database?

Robby

–
Robby R.
Chief Evangelist, Partner

PLANET ARGON, LLC
design // development // hosting

http://www.robbyonrails.com/
aim: planetargon

+1 503 445 2457
+1 877 55 ARGON [toll free]
+1 815 642 4068 [fax]

3

The server increment the id, i only check locally and there i didn’t
have that. So thank you for make me check that, so my problem is solved.

thanks

Assuming that you’re following conventions, sqlite should
automatically increment the id with each new record. Did you use
migrations to create the database?

Chief Evangelist, Partner

PLANET ARGON, LLC
design // development // hosting

http://www.planetargon.com/
http://www.robbyonrails.com/
aim: planetargon

+1 503 445 2457
+1 877 55 ARGON [toll free]
+1 815 642 4068 [fax]