RE: [RBASE-L] - Lost rows
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.
Re: [RBASE-L] - Lost rows
If you are using SQL Grant/Revoke, you can deny delete on any table for all but the owner. If not, you can certainly add it to your system. Razzak’s ate web site has a comprehensive article on the use of Grant/Revoke to prevent troubles with your data. Albert > On Feb 8, 2018, at 10:15 AM, Buddy Walker wrote: > > Dick > Have you re-loaded/packed the database recently. I would suggest pack keys > for the table in question. It could be the index is corrupt and the row is > not really deleted. > > If the row is actually deleted I would suggest putting an On Before DELETE > trigger on the table. This way you could get the row information and insert > into tblDeletions and add username to that row. This way you will know who > is doing the deletions. > > Buddy > > > -Original Message- > From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of > Carpet Broker, Dick Fey > Sent: Thursday, February 8, 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. -- 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.
RE: [RBASE-L] - Lost rows
Dick Have you re-loaded/packed the database recently. I would suggest pack keys for the table in question. It could be the index is corrupt and the row is not really deleted. If the row is actually deleted I would suggest putting an On Before DELETE trigger on the table. This way you could get the row information and insert into tblDeletions and add username to that row. This way you will know who is doing the deletions. Buddy -Original Message- From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of Carpet Broker, Dick Fey Sent: Thursday, February 8, 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.
RE: [RBASE-L] - Lost rows
Do they have access to the data at the table level? If not, then you can use the table setting to not allow deletes. You can do table level permissions as well. I do not give users table level access. They only have the compiled app so I can control/log what we need. Dan Goldberg -Original Message- From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of Carpet Broker, Dick Fey Sent: Thursday, February 8, 2018 7: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.
Re: [RBASE-L] - Lost rows
Dick: Is it at all possible that, at the time these order detail rows are printed, they're actually stored within a temporary order detail table; and that by virtue of a (seemingly) random "glitch", they're not getting written to a permanent order detail table at the appropriate moment? Bruce Chitiea SafeSectors, Inc. -- Original Message -- Sent: 2/8/2018 7:45:36 AM Subject: [RBASE-L] - Lost rows From: "Carpet Broker, Dick Fey" To: "RBase Maillist" Cc: 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.
[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.