Thanks for the clarification. So my proper syntax for inserts with AUTOINCREMENT is one of,
INSERT INTO Structure VALUES(null,'phosphoserine','phosphoserine.mol',185073,856147,73543,25338,'C3H8NO6P',185.073); or INSERT INTO Structure(id, name, filePath, iH1, iH2, iH3, iH4, formula, fw) VALUES(null,'phosphoserine','phosphoserine.mol',185073,856147,73543,25338,'C3H8NO6P',185.073); or INSERT INTO Structure(name, filePath, iH1, iH2, iH3, iH4, formula, fw) VALUES('phosphoserine','phosphoserine.mol',185073,856147,73543,25338,'C3H8NO6P',185.073); As it happens, some of the text strings that will be added to the database have single quotes, N,N'-dimethylethylenediamine do I need to do anything different for these, such as to escape the single single-quote in some way? There will never be double quotes, but there could be any number of single quotes. N,N',N''-trimethylbis(hexamethylene)triamine These single-quotes will never appear as the first or last character, so possibly nothing needs to be done? *LMHmedchem* -- View this message in context: http://sqlite.1065341.n5.nabble.com/inserting-record-data-into-mutliple-tables-with-a-composite-primary-key-tp64874p65524.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users