Re: [sqlite] How to refer to a multiple-column primary key (PK) as 1 column (field) name

On 5/07/2009 5:49 AM, James Scott wrote: > I have the following: > > CREATE TABLE [Sections] ( > [Department] varchar NOT NULL COLLATE NOCASE, > [Course] varchar NOT NULL COLLATE NOCASE, > [Section] varchar NOT NULL COLLATE NOCASE, > [Class_Time] timestamp, > [I_Id] varchar COLLATE NOCAS

Re: [sqlite] How to refer to a multiple-column primary key (PK) as 1 column (field) name

On 4 Jul 2009, at 8:49pm, James Scott wrote: > CREATE INDEX [PK_Sections] ON [Sections] ([Department], [Course], > [Section]); > > In the programming language, I need to refer to the primary key as 1 > field. > Does Sqlite allow a 'calculated field', such as concatenation of the 3 > columns in

[sqlite] How to refer to a multiple-column primary key (PK) as 1 column (field) name

I have the following: CREATE TABLE [Sections] ( [Department] varchar NOT NULL COLLATE NOCASE, [Course] varchar NOT NULL COLLATE NOCASE, [Section] varchar NOT NULL COLLATE NOCASE, [Class_Time] timestamp, [I_Id] varchar COLLATE NOCASE, [Room] varchar COLLATE NOCASE, CONSTRAINT [sqlite_