Re: DELETE Statement Apparently Not Working

Rich Shepard <[email protected]> Wed, 3 Oct 2007 07:53:53 -0700 (PDT)

Newsgroups	gmane.comp.python.db.pysqlite.user
Message-ID	<[email protected]>

On Wed, 3 Oct 2007, Adrian Klaver wrote:

> Glad it worked out. In your original post you mentioned wanting to set up
> cascading deletes. You might find the URL below helpful.
> http://www.sqlite.org/cvstrac/wiki?p=ForeignKeyTriggers

Adrian,

   I had written triggers for some deletes, but not all. I fixed that while
my first post was aging on the list.

   Would be much easier to write 'ON DELETE CASCADE' but in the meantime,
triggers will do.

Thanks again,

Rich

-- 
Richard B. Shepard, Ph.D.               |    The Environmental Permitting
Applied Ecosystem Services, Inc.        |         Accelerators(TM)
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863