I think the issue is whether the version of the sqlite drivers in
LiveCode are up to date enough to include foreign key support at all.
According to http://www.sqlite.org/foreignkeys.html, foreign keys were
supported as of SQlite version 3.6.19 but I don;t know how to find out
what version of sqlite is included with LiveCode. If foreign key
support is included, it's off by default so you do have to enable it
as detailed by Trevor.
Pete Haworth
On Sep 28, 2010, at 10:00 AM, [email protected]
wrote:
Message: 14
Date: Tue, 28 Sep 2010 07:53:40 -0400
From: Trevor DeVore <[email protected]>
Subject: Re: sqlite: foreign keys
To: How to use Revolution <[email protected]>
Message-ID: <[email protected]>
Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes
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
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
