Re: Integrity checks

2001-06-28 Thread ryc
When you delete a row from a table that may be referenced in another table... you must delete all references to it from the other tables. This is done in the same way in which you deleted the first row... ryan > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > As long as MySQL doesn't manage

Integrity checks

2001-06-28 Thread Nicolas Villatte
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 As long as MySQL doesn't manage the foreign keys, how do you manage the deletion of a record if it is referenced in another table's record? I am working in ASP, but I will be intersted by solution in any programming language. Thanks, Nicolas. pas