Am 29.12.2007 um 13:59 schrieb Kees Nuyt:
Hi Lothar,
On Sat, 29 Dec 2007 13:13:04 +0100, Lothar Behrens
<[EMAIL PROTECTED]> wrote:
The only implementation I'm aware of is the one using triggers,
but the creation is not implemented as an extension.
http://www.sqlite.org/cvstrac/wiki?p=ForeignKeyTriggers
http://www.sqlite.org/contrib (second entry)
http://www.justatheory.com/computers/databases/sqlite/
foreign_key_triggers.html
http://www.rcs-comp.com/site/index.php/view/Utilities-
SQLite_foreign_key_trigger_generator
Thanks, Lothar
In general this will help. But I have encountered a problem:
create table IF NOT EXISTS regressiontest (
id int primary key,
test char(100)
);
create table IF NOT EXISTS test (
id int primary key,
id_reg int,
constraint fk_reg foreign key (id_reg) references regression (id)
);
First problem (propably only in sqliteman):
The statement could not be executed at once ??
Second problem:
The constraint is really ignored. (Referencing a non existent table)
I have no idea how to catch this while creating the tables (triggers
are not possible on system tables).
I may create a consistency check while opening the database.
Any ideas on this ?
Thanks, Lothar
--
Lothar Behrens | Rapid Prototyping ...
Heinrich-Scheufelen-Platz 2 |
73252 Lenningen | www.lollisoft.de
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------