Karen
My first thought was primary and foreign keys with cascade. So when you
delete row with primary key system deletes foreign key????
Buddy
Sent from my iPhone
> On Mar 11, 2022, at 7:01 PM, 'Karen Tellef' via RBASE-L
> <rbase-l@googlegroups.com> wrote:
>
>
>
> Why I needed the before-delete trigger: no one should ever be deleting data
> from this table. And although they have the full version of RBase, no one
> knows how to "get to the R> prompt". There is a monthend routine that the
> senior user runs that will delete a batch of data, but that's all (we remove
> the trigger before this monthend routine, then put it back on)
>
> Yet every now and then we find data mysteriously disappeared.
>
> So I created a before-delete trigger. It takes the record to be deleted and
> appends it to an archive table. 3 columns in the archive table will hold the
> deleted date / time and the user who deleted it. Works perfectly at my
> development environment and when I test it at the place where the database is
> installed. Records the date, time and the user.
>
> However, twice now we have found records in that archive table that had been
> deleted (hundreds at a time). The records had the deleted date/time but had
> NO user name.
>
> Here's the code I use in my stored procedure. The DeletedDate and
> DeletedTime works fine, it gets updated every time. There is no login to
> this app, so I grab the NetUser (used many times in the application for other
> things, successfully). The first time that the archive had no user name, I
> modified the stored procedure to grab the ComputerName. But still,
> nothing.....
>
>
> SET VAR vText TEXT = NULL
> SET VAR vText = (CVAL("NetUser"))
> IF vText IS NULL THEN
> SET VAR vText = (CVAL("ComputerName"))
> ENDIF
>
> UPDATE ClaimsDeleted SET DeletedDate = .#DATE, DeletedTime = .#TIME, +
> DeletedBy = .vText WHERE claim = .spClaim
>
>
>
> Can anyone think of anything else I can trap that would help me figure out
> how/when the records got deleted?
>
> Or does anyone know how records could get deleted when there actually is no
> NetUser or ComputerName?
>
>
> Karen
>
>
> --
> 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.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/rbase-l/1654695576.980450.1647043308102%40mail.yahoo.com.
--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/C98666B1-D52E-444A-A976-2230F7941E53%40comcast.net.
