我有一个WPF应用程序,通过ADO.NET (http://adodotnetsqlite.sourceforge.net/) 访问SQLite数据库。到目前为止一切都正常,但是当我尝试执行以下SQL语句时:
sqlite_cmd.CommandText = "CREATE TABLE IF NOT EXISTS notes (id integer primary key, text varchar(100));";
sqlite_cmd.ExecuteNonQuery();
我遇到了以下异常:
An exception of type 'Finisar.SQLite.SQLiteException' occurred in SQLite.NET.dll but was not handled in user code.
Additional information: near "NOT": syntax error
当我移除 IF NOT EXISTS
部分时,它可以正常工作,但我只想在表不存在时才创建它。我做错了什么吗?
IF NOT EXISTS
... - Jeff