KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I can find syntax "charts" on this on the SQLite website, but no examples and my code is crashing. I have other tables with unique constraints on a single column, but I want to add a constraint to the table on two columns. This is what I have that is causing an SQLiteException with the message "syntax error". CREATE TABLE name (column defs) UNIQUE (col_name1, col_name2) ON CONFLICT REPLACE I'm doing this based on the following: table-constraint To be clear, the documentation on the link I provided says that CONTSTRAINT name should come before my constraint definition. Something that may lead to the solution though is that whatever follows my parenthesized column definitions is what the debugger complains about. If I put ...last_column_name last_col_datatype) CONSTRAINT ... the error is near "CONSTRAINT": syntax error If I put ...last_column_name last_col_datatype) UNIQUE ... the error is near "UNIQUE": syntax error
Tags (comma-separated)
Save Edits
Cancel