-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Dennis Cote
Sent: Monday, March 03, 2008 6:38 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Can I automatically create a 'disambiguation' number
in a second field of a primary key?
Paul
"Paul Hilton" <[EMAIL PROTECTED]> wrote:
>
> Here is the problem: I want Slot created to disambiguate the Primary Key, So
> that for every value of Group the value of Slot starts at 1 and counts up.
These are two different things:
(1) Slot needs to disambiguate the PRIMARY KEY
(2) Slot
Paul Hilton wrote:
>
> Thanks for the suggestion,
>
> However it doesn't solve my problem, perhaps because of something I failed
> to say.
>
> I am intending to use these 'Slot' numbers to schedule experiments between
> talkers and listeners.
> The 'Slot' refers to a time slot.
> I would like
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Dennis Cote
Sent: Monday, March 03, 2008 4:17 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Can I automatically create a 'disambiguation' number
in a second field of a primary key?
Paul Hilton wrote:
> Hello,
>
> I have source tables Talker and Listener, each with fields ID (PK, Integer)
> and Group (Integer):
>
> CREATE TABLE Talker (ID INTEGER, Group INTEGER, Primary Key (ID));
> Ditto Listener
>
> I would like to make a table Communications with fields Group (PK,
5 matches
Mail list logo
