CREATE TABLE JobCode (JobCodeID Integer, JobCodeDescription varchar(50), primary key (JobCodeID) ); Insert into JobCode values (1, "Customer Service Representative"); Insert into JobCode values (2, "Marketing specialist"); Insert into JobCode values (3, "Project manager"); Insert into JobCode values (4, "Order clerk"); Insert into JobCode values (5, "Web developer"); Insert into JobCode values (6, "Content writer");

Response getting is: SQLITE_ERROR: sqlite3 result code 1: no such column: "Customer Service Representative" - should this be a string literal in single-quotes?

Try replacing the double-quotes with single quotes. It'll work then. Double-quotes means 'use this as a column name', not 'use this as a literal string'.

Eg

Insert into JobCode values (1, 'Customer Service Representative');

Then read #8 on this page. You may as well read the others too, as you're not familiar with SQLite.

https://www.sqlite.org/quirks.html#double_quoted_string_literals_are_accepted

Thank you. But when I do that,I get: SQLITE_CONSTRAINT_PRIMARYKEY: sqlite3 result code 1555: UNIQUE constraint failed: JobCode.JobCodeID

Thank you

INSERT INTO JobCode (JobCodeDescription) VALUES ('Customer Service Representative');

BTW:

CREATE TABLE JobCode(Id INTEGER PRIMARY KEY, Description TEXT);

Will explicitly use the Id as an alias for the internal rowid.

Also, consider that field names do not need to include the table name. If two (or more) tables with identically named fields (or the same table more than once) are present in the same SELECT statement, then it is probably necessary to assign aliases to tables and qualify field names with table aliases anyway.

Thank you