Dick, Does this issue surface later in the work day or the following day? Has the program worked perfectly daily up to some recent point when the issue surfaced? If so, what might have changed recently? Server, users, program? Perhaps this might help lead you towards a solution. If this is happening during the day, I would think that the later responses in this thread should solve your problem if someone or something is deleting rows, for whatever reason. While a deletion lock at the table level seems like a good idea, perhaps saving the deleted rows along with the user information in another table as Buddy suggested, might be more useful, if for no other reason than revealing why it is happening, which may very well lead to deletion locks at the table level as a solution or some other solution.
Steve -----Original Message----- From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of Carpet Broker, Dick Fey Sent: Thursday, February 08, 2018 10:46 AM To: RBase Maillist Subject: [RBASE-L] - Lost rows Help... We are having a problem with occasional rows just disappearing from a table. We know they were there in the beginning, because we print an order when entered. Sometimes coming back to the order later, 1 or more detail rows are missing. I have no idea how that can happen. The question is.... Can I make it impossible for rows to be deleted from a table under any circumstances ? Found a rule restricting deletion, but not absolute. Any ideas would be helpful. Thanks, Dick Fey -- Carpet Broker Inc P: 913-894-9211 F: 913-894-0138 -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
