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

Reply via email to