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. Dan. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users