CREATE TABLE Exam( examID TEXT PRIMARY KEY NOT NULL
I will also add, as most inexperienced programmers do, "but it worked before". The database was created with older version of SQLITE and the code worked with the same older version. Could it matter? Thank you, Roman ________________________________________ From: sqlite-users-bounces at mailinglists.sqlite.org [sqlite-users-bounces at mailinglists.sqlite.org] on behalf of Simon Slavin [slav...@bigfraud.org] Sent: Tuesday, May 19, 2015 1:52 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] select * where is/like ? On 19 May 2015, at 5:51am, Roman Fleysher <roman.fleysher at einstein.yu.edu> wrote: > Why does not last SQL query produce nothing? What is the schema (the CREATE TABLE command) for your Exam table ? Simon. _______________________________________________ sqlite-users mailing list sqlite-users at mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users