CodeCharge Studio
search Register Login  

Visual PHP Web Development

Visually Create Internationalized Web Applications, Web Reports, Calendars, and more.
CodeCharge.com

YesSoftware Forums -> Archive -> GotoCode Archive

 delete from two tables

Print topic Send  topic

Author Message
notex
Posted: 05/02/2003, 6:00 AM

I have two tables, contact_list and contact_person. When some delete contact_person record, all related entries in contact_list should be cascade delete as well.

Just wondering how to do two delete from sql in ccs.

Though I don't expect any answer here
Edd
Posted: 05/03/2003, 12:04 AM

The best method is to put it into a trigger in the database so the rules are consistent.

If you can't use a trigger (i.e. MySQL) then in the AfterDelete event code the delete of the subsequent data,

Hope this helps :-)

Edd

   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.

CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.