Thread: Pragma foreign keys = ON;?
View Single Post
  #5  
Old 05-03-2014, 12:20 AM
fowlplay4 fowlplay4 is offline
team canada
fowlplay4's Avatar
Join Date: Jul 2004
Location: Canada
Posts: 5,200
fowlplay4 has a reputation beyond reputefowlplay4 has a reputation beyond reputefowlplay4 has a reputation beyond reputefowlplay4 has a reputation beyond reputefowlplay4 has a reputation beyond reputefowlplay4 has a reputation beyond reputefowlplay4 has a reputation beyond reputefowlplay4 has a reputation beyond reputefowlplay4 has a reputation beyond reputefowlplay4 has a reputation beyond reputefowlplay4 has a reputation beyond repute
Our version of SQLite is out of date so just write your own DELETE queries.

http://sqlite.org/foreignkeys.html

This document describes the support for SQL foreign key constraints introduced in SQLite version 3.6.19.

> temp.res = SQL.executeSQL("select sqlite_version() AS sqliteversion", true);
> echo(temp.res.rows[0].sqliteversion);

echos 3.6.12
__________________
Quote:
Reply With Quote