Hello,
i have written a sqlite3-db for a small books library. Within this db
there is a table:
sqlite .schema ausleihen
CREATE TABLE ausleihen (
aid INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
pid INTEGER NOT NULL,
beid INTEGER NOT NULL,
ausleihdatum DATE NOT NULL,
On 06/10/2012 08:35 PM, Wolfgang Meiners wrote:
So my question is: (how) can i write an integrity constraint in sqlite3
(version 3.6.12) which is equivalent to the part
SELECT CASE
WHEN EXISTS (SELECT * FROM ausleihen
WHERE (beid =
On Jun 10, 2012, at 2:35 PM, Wolfgang Meiners wrote:
So my question is: (how) can i write an integrity constraint in sqlite3
The short of it is that you can't. SQLite doesn't support such constraints.
Only the basics are supported: primary, unique, referential, not null, check:
Am 10.06.12 14:49, schrieb Guenther Boelter:
On 06/10/2012 08:35 PM, Wolfgang Meiners wrote:
So my question is: (how) can i write an integrity constraint in sqlite3
(version 3.6.12) which is equivalent to the part
SELECT CASE
WHEN EXISTS (SELECT * FROM ausleihen