[sqlite] Can I automatically create a 'disambiguation' number in a second field of a primary key?

47 15 2 2 15 47 2 3 37 47 2 4 37 15 Thanks for any help. Paul Hilton

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 wit

Re: [sqlite] Can I automatically create a 'disambiguation' number in a second field of a primary key?

sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users Dennis, That helps a lot, and I think I understand it. I've not used triggers before, nor a select without a from, nor the coalesce function. I presume that if I don't care about the order of records then I don't nee

[sqlite] Limiting the number of results from a query per group

simultaneous groups as there are. I will then mark these IDs as done, and go on to the next lot until they are all done. Paul Hilton ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Limiting the number of results from a query per group

-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Igor Tandetnik Sent: Thursday, March 06, 2008 7:57 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Limiting the number of results from a query per group "Paul Hilton" <[EMAIL PROT