On Mon, 20 Jul 2009, Simon Slavin wrote: > Rather than move genfkey, it would make more sense to implement foreign > key constraints, since that's what it pretends to implement. However, I > don't know enough about how SQLite works internally to know how difficult > this would be.
Simon, I use triggers to enforce referential integrity with foreign keys. Is this not a suitable approach for what you want to do? Rich -- Richard B. Shepard, Ph.D. | Integrity Credibility Applied Ecosystem Services, Inc. | Innovation <http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users