On Jun 1, 2010, at 11:09 PM, Dan Kennedy wrote: > > On Jun 2, 2010, at 11:41 AM, Scott Frankel wrote: > >> >> Hi all, >> >> I've been lurking for a few days while I explore SQLite and find >> myself now with a question. >> >> What's the correct usage for the "ON DELETE NO ACTION" statement? >> >> I'm converting a schema file to SQLite. Executing a create table >> statement on the sqlite3 cmd-line, ON DELETE NO ACTION yields an >> error: SQL error: near "ON": syntax error. Yet according to the >> docs: "NO ACTION" is a valid action. >> >> Is the absence of the ON DELETE rule itself (example 2 below) >> equivalent to specifying "ON DELETE NO ACTION?" What concept am I >> missing from the docs? ;) > > Could be that you need SQLite version 3.6.19 or later.
I wound up changing the line to ON DELETE CASCADE. My base install of SQLite is happy and the behavior seems right. Thanks for the tip Scott > > Dan. > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
