Re: [sqlite] Support of cascading updates and deletes

[Richard Hipp]

On Tue, Oct 16, 2012 at 7:12 PM, Kris Peters  wrote:

> I¹m new to sqlite; I took the lazy way out and downloaded the sqlite3
> precompiled binaries for Mac OS X. Creating tables, doing queries, and
> noncascading deletes and updates work fine.  But specifying any kind of
> cascading update and deletes seems to be ignored. What do you recommend?
>

PRAGMA foreign_keys=ON;

http://www.sqlite.org/pragma.html#pragma_foreign_keys



>
> Kris Peters
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Support of cascading updates and deletes

[Kris Peters]

I¹m new to sqlite; I took the lazy way out and downloaded the sqlite3
precompiled binaries for Mac OS X. Creating tables, doing queries, and
noncascading deletes and updates work fine.  But specifying any kind of
cascading update and deletes seems to be ignored. What do you recommend?

Kris Peters

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users