sqlite: foreign keys

[Trevor DeVore]

On Sep 25, 2010, at 3:42 PM, David Bovill wrote:

> A quick geeky question: does anyone know if foreign key support has  
> been
> turned on for the recent sqlite driver

I don't think you need to turn it on when compiling. It is a pragma  
setting:

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

Untested but try this:

revExecuteSQL theConnectionID, "PRAGMA foreign_keys = true"

-- 
Trevor DeVore
Blue Mango Learning Systems
ScreenSteps: http://www.screensteps.com
Releasable Revolution Resources for Developers: http://revolution.bluemangolearning.com