-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On 2001 November 23 02:55 am, you wrote:
> >> CKL> ie. ALTER TABLE activities ADD FOREIGN KEY (job_id)
> >> REFERENCES jobs(job_id)
> >> CKL> ON DELETE CASCADE;
>
> CKL> My ALTER TABLE statement above will do exactly this.
>
> CKL> It will delete activities when a job is deleted. Try it in a test
> database.
>
> But also need delete activities!
Which is exactly what this will do. When you ask for help, you might want
to try what people suggest. If you had tried what Chris suggested (twice!)
you would have discovered that his suggestion solves the problem you have
described. Please respect the time and effort of volunteers answering
questions in this forum. You can do this best by devoting some time and
effort to thinking about and learning from the responses posted. At least
try a suggested solution before complaining that it doesn't work!
- --
Andrew G. Hammond mailto:drew@xyzzy.dhs.org http://xyzzy.dhs.org/~drew/
56 2A 54 EF 19 C0 3B 43 72 69 5B E3 69 5B A1 1F 613-389-5481
5CD3 62B0 254B DEB1 86E0 8959 093E F70A B457 84B1
"To blow recursion you must first blow recur" -- me
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org
iEUEARECAAYFAjv/aroACgkQCT73CrRXhLEZJACeKGkoYQ65+yMO99rBFiizjSIz
YgcAli4uE+9/e5JkfP8DMqzeXdPMbRQ=
=F89I
-----END PGP SIGNATURE-----