Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: David Mustakim
  Where is David Mustakim?
 Jakarta
 Indonesia
 David Mustakim
 To: Jim Carls
  Where is Jim Carls?
 Nashville
 Tennessee - United States
 Jim Carls
 Tags
Subject: RE: Cascading deletes not deleting
Thread ID: 395635 Message ID: 395643 # Views: 33 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Thursday, January 16, 2014 5:00:03 PM         
   


> > CMIIW but my understanding based on actual use on my accounting application the RI-"cascading" applies to one relation as specifically defined between two tables. It does not cascade further down to grand-child tables ( see Help no mention of the term "grand-" ... but tonight I'd probably testing it as I didn't really use it for anymore than 1 level)
> >
> > David
> >
> >
>
> That also occurred to me, but the cascading of the deletes on the "design" side of the tables has been working for years and deletes not just grandchildren but great-grandchildren, too. I also manually deleted an order and it deleted its granchildren. The problem seems to be that the orders are not being deleted at all.


Not quite sure I understand what you mean by "design" side... are there tables and relations created during runtime on the fly? ( ? )
If difference ONLY exists between development and real / actual runtime environments then maybe it is either:
- different runtime dll versions exist in user/server PC
- overall re-install called for now

Regards
David

ENTIRE THREAD

Cascading deletes not deleting Posted by Jim Carls @ 1/16/2014 3:51:01 PM
RE: Cascading deletes not deleting Posted by Tore Bleken @ 1/16/2014 3:57:14 PM
RE: Cascading deletes not deleting Posted by Jim Carls @ 1/16/2014 4:45:33 PM
RE: Cascading deletes not deleting Posted by Tore Bleken @ 1/16/2014 5:45:53 PM
RE: Cascading deletes not deleting Posted by David Mustakim @ 1/16/2014 4:28:15 PM
RE: Cascading deletes not deleting Posted by Jim Carls @ 1/16/2014 4:50:20 PM
RE: Cascading deletes not deleting Posted by David Mustakim @ 1/16/2014 5:00:03 PM
RE: Cascading deletes not deleting Posted by tom knauf @ 1/16/2014 5:15:43 PM
RE: Cascading deletes not deleting Posted by David Mustakim @ 1/16/2014 5:24:05 PM