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.

@Override  public void onOpen(SQLiteDatabase db)  {   super.onOpen(db);   if (!db.isReadOnly())   {    // Enable foreign key constraints    db.execSQL("PRAGMA foreign_keys=ON;");   }  } 

I declared my referencing column as follows.

mailbox_id INTEGER REFERENCES mailboxes ON DELETE CASCADE





更多相关文章

  1. 代码中设置drawableleft
  2. android 3.0 隐藏 系统标题栏
  3. Android开发中activity切换动画的实现
  4. Android(安卓)学习 笔记_05. 文件下载
  5. Android中直播视频技术探究之—摄像头Camera视频源数据采集解析
  6. 技术博客汇总
  7. android 2.3 wifi (一)
  8. AndRoid Notification的清空和修改
  9. Android中的Chronometer

随机推荐

  1. android常用代码积累
  2. 初学Android时遇到的一些错误及解决办法
  3. Android Jetpack-Navigation简单使用
  4. 通过Button改变TextView文字颜色
  5. Android AlertDialog包含EditText,软键盘
  6. Android学习笔记1 ——资源 (一)
  7. android之EditText文本监听(addTextChang
  8. android中封装http请求
  9. 关于android studio报错Attempt to invok
  10. android使程序进程不被LMK杀死