Hi Lothar, On Sat, 29 Dec 2007 13:13:04 +0100, Lothar Behrens <[EMAIL PROTECTED]> wrote:
>Hi all, > >now I have got more information on how to implement foreign key support. > >My plan is to use extension functions to do it by parsing the system >table's sql statement and returning >a result set array or the like. > >Before I start implementing the extension, has someone done such an >implementation that could be reused ? >(public domain or LGPL is preferred) 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 Hope this helps. -- ( Kees Nuyt ) c[_] ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------