Adrian: I am assuming they were actually deleted. Since the trigger is
"before delete" and operates as it should other than giving me that null
DeletedBy, and I can't find them anywhere in the original table, I have to
think they were deleted. If there was an issue with indexes or a database
problem itself, I would think it would show up on an Autochk. This database
has never had a bad Autochk.
Karen
-----Original Message-----
From: Adrian Huessy <[email protected]>
To: [email protected] <[email protected]>
Sent: Sat, Mar 12, 2022 11:14 am
Subject: RE: [RBASE-L] - Delete Trigger mystery?
<!--#yiv4891551485 _filtered {} _filtered {} _filtered {}#yiv4891551485
#yiv4891551485 p.yiv4891551485MsoNormal, #yiv4891551485
li.yiv4891551485MsoNormal, #yiv4891551485 div.yiv4891551485MsoNormal
{margin:0cm;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New
Roman", "serif";}#yiv4891551485 a:link, #yiv4891551485
span.yiv4891551485MsoHyperlink
{color:blue;text-decoration:underline;}#yiv4891551485 a:visited, #yiv4891551485
span.yiv4891551485MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}#yiv4891551485 p
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;font-family:"Times New
Roman", "serif";}#yiv4891551485 span.yiv4891551485E-MailFormatvorlage18
{font-family:"Calibri", "sans-serif";color:#1F497D;}#yiv4891551485
.yiv4891551485MsoChpDefault {font-family:"Calibri", "sans-serif";} _filtered
{}#yiv4891551485 div.yiv4891551485WordSection1 {}-->Karen,Quick question: do
you feel that records are/were effectively deleted or do you have NULL entries
even though nothing was deleted?BR, Adrian Von: 'Karen Tellef' via RBASE-L
[mailto:[email protected]]
Gesendet: Samstag, 12. März 2022 01:02
An: [email protected]
Betreff: [RBASE-L] - Delete Trigger mystery? 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 [email protected].
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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/dbba74c3572c4f6aa054b424fd42d70b%40huessy.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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/840423822.1120239.1647114324158%40mail.yahoo.com.
