Hi all, thanks for the infor on foreign keys, helps a lot.
Thanks again
John
On 10/08/06, A. Pagaltzis <[EMAIL PROTECTED]> wrote:
* John Newby <[EMAIL PROTECTED]> [2006-08-10 00:25]:
> it recognises them if you put them in your create table
> statement but it does not enforce them, is this correct?
Yes. But note that you can retrofit enforcement yourself. Take a
look at
Enforce Foreign Key Integrity in SQLite with Triggers
http://www.justatheory.com/computers/databases/sqlite/foreign_key_triggers.html
Regards,
--
Aristotle Pagaltzis // <http://plasmasturm.org/>
