home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.paradox      To crash or not to crash, asks Borland      9,834 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 7,936 of 9,834   
   Sundial Services to Kenneth   
   Re: A strange "deletion" situation...?   
   21 Nov 06 15:59:54   
   
   From: info@sundialservices.com   
      
   Kenneth wrote:   
   > When I re-entered my own ID number, last name, and first   
   > name in the parent table, all of the linked data appeared   
   > properly in our primary form.   
   >   
   > Using the form, how might it have been possible to delete   
   > the name information without first deleting all the   
   > information in the child tables?   
   >   
   > If I am understanding this correctly, there is no simple act   
   > that could have accidentally caused the problem, but I   
   > certainly want to be sure that it does not happen again.   
      
   It would be difficult to discern what did happen.  There are no auditing   
   capabilities in Paradox.   
      
   Does your form include code to remove child-records?  If so, then the   
   absence of "only a master record" implies that your form wasn't used.  If   
   not, then yes, it is certainly possible for only the master to be deleted   
   without affecting the children.   
      
   It might be useful to run queries to see if there are any /other/ "missing   
   masters."   
      
   I do not consider it profitable to /assume/ that malicious intent is   
   indicated here.  It's actually fairly unlikely.   
      
   ----   
   ChimneySweep(R): Fast(!) table repair at a click of the mouse!   
   http://www.sundialservices.com   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca