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 <RBASE-L@GoogleGroups.com>
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.

Reply via email to