changed the message to the user.
So far no more deletes have happened. We still have no clues how it happens
when it does
Karen
-Original Message-
From: 'James Bentley' via RBASE-L
To: rbase-l@googlegroups.com
Sent: Thu, Mar 31, 2022 4:30 am
Subject: Re: [RBASE-L] -
Karen,Search RBase Help for SYS_OLD used in the command element WHERE CURRENT
OF SYS_OLD in the BEFORE DELETE trigger.Be aware that access to SYS_OLD record
is only available in the BEFORE DELETE trigger not in an AFTER DELETE trigger
where according to SQL syntax where the update of the archive
orth a try using those 2 other identifiers!
Karen
-Original Message-
From: Doug Hamilton
To: rbase-l@googlegroups.com
Sent: Tue, Mar 15, 2022 1:23 pm
Subject: Re: [RBASE-L] - Delete Trigger mystery?
I set up a DBActivityLogger table to track various events when/where needed.
I set variabl
e one deleting, but I
can't say I'm 100% on board with that.
Karen
-Original Message-
From: baue...@gmail.com
To: RBASE-L
Sent: Tue, Mar 15, 2022 11:32 am
Subject: Re: [RBASE-L] - Delete Trigger mystery?
At this juncture, I would go straight to the GRANT on permissio
he table that the Before Delete Trigger
>>> saves to, so it's an easy "append". Much easier than RScope!
>>>
>>> Karen
>>>
>>>
>>>
>>> -Original Message-
>>> From: baue...@gmail.com
>>> To: RBASE-L
>>> Sent:
>>
>> Karen
>>
>>
>>
>> -Original Message-
>> From: baue...@gmail.com
>> To: RBASE-L
>> Sent: Tue, Mar 15, 2022 9:41 am
>> Subject: Re: [RBASE-L] - Delete Trigger mystery?
>>
>> Also, If you did NOT know, since the
Message-
> From: baue...@gmail.com
> To: RBASE-L
> Sent: Tue, Mar 15, 2022 9:41 am
> Subject: Re: [RBASE-L] - Delete Trigger mystery?
>
> Also, If you did NOT know, since the DB is not damaged, those deleted rows
> are recovered fairly easily with R:Scope.
>
> From
They are stored nicely in the table that the Before Delete Trigger saves to, so
it's an easy "append". Much easier than RScope!
Karen
-Original Message-
From: baue...@gmail.com
To: RBASE-L
Sent: Tue, Mar 15, 2022 9:41 am
Subject: Re: [RBASE-L] - Delete Trigger mys
> Sent: Tue, Mar 15, 2022 9:06 am
> Subject: Re: [RBASE-L] - Delete Trigger mystery?
>
> But you also know that when the deletion is limited to EXACT rows and not
> random gaps in the data file, that the deletions are occurring from one of
> two sources. Programmatically or direc
/ out (only 4 users)
Karen
-Original Message-
From: baue...@gmail.com
To: RBASE-L
Sent: Tue, Mar 15, 2022 9:06 am
Subject: Re: [RBASE-L] - Delete Trigger mystery?
But you also know that when the deletion is limited to EXACT rows and not
random gaps in the data file, that the dele
t;
>
> -Original Message-
> From: baue...@gmail.com
> To: RBASE-L
> Sent: Mon, Mar 14, 2022 3:23 pm
> Subject: Re: [RBASE-L] - Delete Trigger mystery?
>
> A "Delete Flag" is just a single character field that excludes the record
> from any results. It is in l
From: baue...@gmail.com
To: RBASE-L
Sent: Mon, Mar 14, 2022 3:23 pm
Subject: Re: [RBASE-L] - Delete Trigger mystery?
A "Delete Flag" is just a single character field that excludes the record from
any results. It is in lieu of "Actual" deletion. Internally, I believe R:
ded. Only one user has the password to run
> that routine and the monthend date is never the one that is erroneously
> deleting records.
>
>
> Karen
>
>
> -Original Message-
> From: baue...@gmail.com
> To: RBASE-L
> Sent: Sun, Mar 13, 2022 9:04 am
> Subjec
---
From: baue...@gmail.com
To: RBASE-L
Sent: Sun, Mar 13, 2022 9:04 am
Subject: Re: [RBASE-L] - Delete Trigger mystery?
Well it might take a little work, but this is what I would do. #1 - I would
lock the table down with access control as tight as practically possible.
Add a single character fi
2 USING "OKAY TO DELETE"
RETURN
I'm going to ask them if they want to try this, thanks!
Karen
-Original Message-
From: Robert Thompson
To: 'Karen Tellef' via RBASE-L
Sent: Sun, Mar 13, 2022 12:21 pm
Subject: Re: [RBASE-L] - Delete Trigger mystery?
Karen,
want her to check anyway.
Karen
-Original Message-----
From: Doug Hamilton
To: rbase-l@googlegroups.com
Sent: Sun, Mar 13, 2022 10:51 am
Subject: Re: [RBASE-L] - Delete Trigger mystery?
What about using FIND in Custom EEPS, Expressions and Control
Properties in all forms for:
DEL ROWS
to ask each
person if they've ever run DOS. These people rate a 0.01 on technical skills,
so they couldn't figure out a way around it. But I want her to check anyway.
Karen
-Original Message-----
From: Doug Hamilton
To: rbase-l@googlegroups.com
Sent: Sun, Mar 13, 2022 10:51 am
now of during the past year
Karen
-Original Message-
From: Adrian Huessy
To: rbase-l@googlegroups.com
Sent: Sat, Mar 12, 2022 2:52 pm
Subject: RE: [RBASE-L] - Delete Trigger mystery?
Karen,
Brainstorming without knowing your application and database: Missing
user and computer name could indicate s
-L [mailto:rba...@googlegroups.com]
> *Gesendet:* Samstag, 12. März 2022 01:02
> *An:* rba...@googlegroups.com
> *Betreff:* [RBASE-L] - Delete Trigger mystery?
>
>
> Why I needed the before-delete trigger: *no one* should ever be deleting
> data from this table. And a
ps.com
Sent: Sat, Mar 12, 2022 2:52 pm
Subject: RE: [RBASE-L] - Delete Trigger mystery?
Karen,Brainstorming without
knowing your application and database: Missing user and computer name could
indicate system user. Access via ODBC/Oterro, other trigger? The way of
deletion may give a hint: are
' via RBASE-L [mailto:rbase-l@googlegroups.com]
Gesendet: Samstag, 12. März 2022 20:45
An: rbase-l@googlegroups.com
Betreff: Re: [RBASE-L] - Delete Trigger mystery?
Adrian: I am assuming they were actually deleted. Since the trigger is
"before delete" and operates as it should
s 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
To: rbase-l@googlegroups.com
Sent: Sat, Mar 12, 2022 11:14 am
Subject: RE: [RBASE-L] - Delete Trigger myster
om
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
---Original Message-
From: Robert Thompson
To: 'Karen Tellef' via RBASE-L
Sent: Fri, Mar 11, 2022 7:43 pm
Subject: Re: [RBASE-L] - Delete Trigger mystery?
A couple of thoughts...(some obvious, but it never hurts to ask!)
Was the Deletedby value actually null or a blank? If it
] - Delete Trigger mystery?
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
wrote:
Why I needed the before-dele
A couple of thoughts...(some obvious, but it never hurts to ask!)
Was the Deletedby value actually null or a blank? If it was blank, then
the computer name would not be captured with the "is null" parameter.
Just in case there is some odd condition with nulls, you could set the
var vtext = (
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
> wrote:
>
>
>
> Why I needed the before-delete trigger: no one
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 (w
28 matches
Mail list logo
