(UTC)
  Lantica User Forum › Lantica Discussions › Lantica Discussion › Problem - Child Records Vanishing
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send Topic Send Topic Print Print
Normal Topic Problem - Child Records Vanishing (Read 912 times)
BWETTLAUFER
Full Member
***
Offline



Posts: 216
Location: Cambridge, Ontario
Joined: Apr 9th, 2010
Problem - Child Records Vanishing
Feb 3rd, 2012 at 1:59am
Print Post Print Post  
Hi all,

I have a problem with my datavbase.  I'm noticing that on a regular basis, I am losing child records.  They are completely vanishing.

My main form is a customer screen, with subforms for notes and payments.  I am finding that I go to a specific record, and all previous notes and payments are vanished from our database. 

I've gone to the subform forms, and there is no record of the notes or payments there.  They aren't being disassociated, just vanishing.

Can you suggest how I can find the root cause of this, and prevent it?

Thanks
  
Back to top
WWW WWW Twitter Twitter  
IP Logged
 
lksseven
Full Member
***
Offline



Posts: 416
Location: Southwest
Joined: Jan 26th, 2009
Re: Problem - Child Records Vanishing
Reply #1 - Feb 3rd, 2012 at 2:40pm
Print Post Print Post  
have you built a command button on the customer screen that 'deletes' selected subform records?

A couple of years ago I was occasionally/randomly losing SOLines records in bulk.  Finally figured out that my programming in my custom 'delete this Sales Order' command button was flawed, and when someone would delete an incorrect sales order, the programming loop wasn't stopping at deleting just the child SOLines records associated with that parent.

Finally figured it out and fixed the problem.  The good news is it gave me some practice in restoring/importing records from a backup  Huh
  
Larry
Back to top
WWW WWW YIM YIM  
IP Logged
 
BWETTLAUFER
Full Member
***
Offline



Posts: 216
Location: Cambridge, Ontario
Joined: Apr 9th, 2010
Re: Problem - Child Records Vanishing
Reply #2 - Feb 5th, 2012 at 4:06am
Print Post Print Post  
Nope, no delete button.

I do have a spec that removes the reference id from a child record when the note is blank, but I went and looked for records being disassociated because the reference id is gone, and that's not the issue.

The child records are just gone.  Period.  No sign of the records anywhere.

As soon as I saw the issue, I immediately upgraded my backup programming.  But I'd like to eliminate the problem, ultimately.
  
Back to top
WWW WWW Twitter Twitter  
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: Problem - Child Records Vanishing
Reply #3 - Feb 7th, 2012 at 6:39pm
Print Post Print Post  
Any chance the users are dittoing the parent and then deleting the original, thus deleting the subrecords?

Next time you notice that child records have disappeared, without closing sesame, put the DB and DAT files into a zip folder and shoot them to support@lantica.com along with as much information you can give me as to the data contained in the parent and some that should be in the kids.

-Ray
  
Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
WWW WWW  
IP Logged
 
BWETTLAUFER
Full Member
***
Offline



Posts: 216
Location: Cambridge, Ontario
Joined: Apr 9th, 2010
Re: Problem - Child Records Vanishing
Reply #4 - Mar 23rd, 2012 at 11:34pm
Print Post Print Post  
Just caught an instance of it ... emailing you now ...
  
Back to top
WWW WWW Twitter Twitter  
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: Problem - Child Records Vanishing
Reply #5 - Mar 28th, 2012 at 8:12pm
Print Post Print Post  
Hello Blair,

Just wanted to let you know I have received the files but have not had enough time to really dig into them to see what is going on with them but I will try and get into them this week.

-Ray
  
Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
WWW WWW  
IP Logged
 
BWETTLAUFER
Full Member
***
Offline



Posts: 216
Location: Cambridge, Ontario
Joined: Apr 9th, 2010
Re: Problem - Child Records Vanishing
Reply #6 - Mar 28th, 2012 at 9:08pm
Print Post Print Post  
Hey Ray ... thanks!  I appreciate that.
  
Back to top
WWW WWW Twitter Twitter  
IP Logged
 
Page Index Toggle Pages: 1
Send Topic Send Topic Print Print
‹ Previous Topic | Next Topic ›
 
  « Board Index ‹ Board Top  

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid RSS Valid XHTML Valid CSS Powered by Perl Source Forge