[Opensource] referance integrity

[Eddie Lewis]

One way is to use the addDetail method in your parent dbobject.
 
in parent dbObject make the reference to your child dbObject
 
i.e. in parentDBObj
addDetail("com.dbobj.childDBObj", "id", "child_id");
 
when you call parentDBObj.delete();
 
any child rows will be deleted automatically and the transaction will commit
after all deletes are successful.
 
If you now call DBMaint?dbobj=parentDBObj you will get the parent and any
child rows in your result.

-----Original Message-----
From: ershad rahimikia [mailto:ershadr at yahoo.com]
Sent: Sunday, 20 October 2002 5:10 AM
To: opensource at jcorporate.com
Subject: [Opensource] referance integrity



Hi 

I have some problems with referential integrity. i found a method in
multiDBObject nearly related to it ,but not exact one. how can I maintain
referential integrity of my tables  in expresso ?

thanks in advance. 




  _____  

Do you Yahoo!?
Y! Web Hosting <http://webhosting.yahoo.com/>  - Let the expert host your
web site

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.jcorporate.com/pipermail/opensource/attachments/20021021/8e5bc4ef/attachment-0002.htm