SQLite would be great to an already great project.
Cheers.
-Original Message-
From: Israel Figueroa [mailto:[EMAIL PROTECTED]
Sent: 03 July 2007 04:06 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Database Level Unique Sequence
I think that what you need is a sequence... but
--- Original Message
From: Andre du Plessis <[EMAIL PROTECTED]>
To: sqlite-users@sqlite.org
Sent: Monday, July 2, 2007 9:36:02 AM
Subject: [sqlite] Database Level Unique Sequence
Good day everyone.
I would like to know how to create an Autoincrement field and insure
that it is unique across
something
similar.
-Clark
- Original Message
From: Andre du Plessis <[EMAIL PROTECTED]>
To: sqlite-users@sqlite.org
Sent: Monday, July 2, 2007 9:36:02 AM
Subject: [sqlite] Database Level Unique Sequence
Good day everyone.
I would like to know how to create an Autoincrement fie
Hello Andre,
I'd probably add a single table that does nothing but, supply
auto-increment values to the other tables. You'd only have
"autoincrement" in this one table then when you need a unique number,
insert into the link table, get the rowid/autoincrement value and then
use this value for the
"P Kishor" <[EMAIL PROTECTED]> wrote:
> On 7/2/07, Andre du Plessis <[EMAIL PROTECTED]> wrote:
> >
> > I would like to know how to create an Autoincrement field and insure
> > that it is unique across the database,
>
> 1. Use a GUID, or
> 2. Use some kind of crypt/md5 kinda function on a random s
Re: "I would like to know how to create an Autoincrement field and
insure that it is unique across the database [not just within one
table]...]
Hi Andre,
Do you mind saying why it is you need the field to be unique across all
tables? Wouldn't the fact that a key is unique within its own table
On 7/2/07, Andre du Plessis <[EMAIL PROTECTED]> wrote:
Good day everyone.
I would like to know how to create an Autoincrement field and insure
that it is unique across the database, I tested this and it does not
seem to work:
..
1. Use a GUID, or
2. Use some kind of crypt/md5 kinda function o
Good day everyone.
I would like to know how to create an Autoincrement field and insure
that it is unique across the database, I tested this and it does not
seem to work:
c:\Temp>sqlite3 temp.db
SQLite version 3.3.17
Enter ".help" for instructions
sqlite> create table temptable (id integ
8 matches
Mail list logo