On Tue, 2006-03-28 at 18:48 +0200, jt wrote: > Could we add a "ForeignKey createSql" -> "FOREIGN KEY(colname) > REFERENCES table(id)" when backend is sqlite. I know sqlite do not > enforce them at the moment (3.3.4) but it parses it and check the > syntax. This could be useful in the future, or just right now if we > need to reflect things at the SQL level (PRAGMA > foreign_key_list(table_name), for example).
There are some tips on the SQLite Wiki for enforcing fk contraints with triggers: http://www.sqlite.org/cvstrac/wiki?p=ForeignKeyTriggers You could look into making SQLObject create the appropriate triggers to enforce the constraints as well. -- Matt Good <[EMAIL PROTECTED]> ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
