are the legislators - P.J. O'Rourke
Dan Fitzgerald
From: Martin Canty [EMAIL PROTECTED]
Reply-To: u2-users@listserver.u2ug.org
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Triggers docs?
Date: Fri, 11 Mar 2005 22:47:35 -0800
Hi Dan,
Attached is a document I wrote (for our monthly newsletter
Dan,
You won't see an attachment. Our list filters out attachments to
minimize the risk of virii and trojans.
- Charles Barouch, Moderator
Dan Fitzgerald wrote:
Martin - I appreciate it, but I didn't see an attachment...
---
u2-users mailing list
u2-users@listserver.u2ug.org
To
Lama
When buying selling are controlled by legislation, the first thing to be
bought sold are the legislators - P.J. O'Rourke
Dan Fitzgerald
From: Moderator [EMAIL PROTECTED]
Reply-To: u2-users@listserver.u2ug.org
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Triggers docs?
Date: Sun, 13
: Re: [U2] Triggers docs?
Ah. I'd forgotten about the filtering. So, Martin, if you get a chance, a
direct email? Thanks.
...although in this particular instance, I think I've seen enough.
Fortunately, all sanctioned updates occur via a standard update subroutine,
so we'll just go
I used this post by Bryan Thorell as a starting point when I set them up for
the first time. BTW, Thanks Bryan!
http://www.indexinfocus.com/dl/u2list/200210/40372.html
-Original Message-
From: Dan Fitzgerald [mailto:[EMAIL PROTECTED]
Sent: Friday, March 11, 2005 10:15 AM
To:
Dan,
I haven't found any additional documentation but I have come across a
serious gotcha. Once you add a trigger to a file it is a SQL file. There is
no going back short of creating a new table. This makes it difficult to move
data between INDIAN's (sp?). I have been unable, even using
The manual is a bit skimpy on triggers. Any supplemetal docs around?
We're trying to track updates to a file; individual items have gone missing
lately. No SQL involvement at all.
Sorry, can't comment on Universe.
For unidata, here's some brief docs I wrote after digging. I found info in
Here is link that might be helpful: (works for both UV UD)
http://www.mindspring.com/~tpackert/unidata_tricks.htm
I have used the index-trigger method to track and record all changes to
a file. It seems to work well; the performance hit has been negligible.
If anyone is interested I will post
PROTECTED] On Behalf Of Scott Ballinger
Sent: 11 March 2005 20:37
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Triggers docs?
Here is link that might be helpful: (works for both UV UD)
http://www.mindspring.com/~tpackert/unidata_tricks.htm
I have used the index-trigger method to track
Subject: RE: [U2] Triggers docs?
How do you track a record being deleted from the file though?
The real trigger mechanism fires with INSERT, UPDATE or DELETE.
If memory serves this type of pseudo-trigger can't differentiate between
a delete and an insert/update.
-Original Message-
From
PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Adrian Matthews
Sent: Friday, March 11, 2005 3:28 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Triggers docs?
How do you track a record being deleted from the file though?
The real trigger mechanism fires with INSERT, UPDATE or DELETE
Ballinger
Pareto Corporation
Edmonds WA USA
206 713 6006
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Adrian Matthews
Sent: Friday, March 11, 2005 1:28 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Triggers docs?
How do you track a record
Must be a Unidata thing. It only gets called once on Universe.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Scott Ballinger
Sent: 11 March 2005 22:29
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Triggers docs?
The trigger is normally called
: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Scott Ballinger
Sent: 11 March 2005 22:55
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Triggers docs?
I should think a little longer before pressing send... It's not that
easy to catch a delete using this kind of trigger. You can test
Hi Dan,
Attached is a document I wrote (for our monthly newsletter) to use
triggers. The example is to trap record corruption, there is coding for
both UniData UniVerse. We found the culprit within 10 minutes of
implementing the trigger!
There is a cost to using triggers though I
Scott Ballinger wrote:
The trigger is normally called twice: the first time you get the
original @RECORD, the second time the new @RECORD. If an item
is new or
being deleted, then the trigger is called only once. I use
named common
to track of where I am and to save old @RECORD, so that I
16 matches
Mail list logo