http://www.sqlite.org/foreignkeys.html "This document describes the support for SQL foreign key constraints introduced in SQLite version 3.6.19."
In Froyo it's SQLite version 3.6.22, so ...
EDIT: to see sqlite version : adb shell sqlite3
http://www.sqlite.org/foreignkeys.html "This document describes the support for SQL foreign key constraints introduced in SQLite version 3.6.19." In Froyo it's SQLite version 3.6.22, so ... EDIT: to see sqlite version : adb shell sqlite3 |
Foreign key constraints with on delete cascade are supported, but you need to enable them. I just added the following to my SQLOpenHelper, which seems to do the trick.
I declared my referencing column as follows.
|