RE: [U2] Triggers docs?

2005-03-13 Thread Dan Fitzgerald
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

Re: [U2] Triggers docs?

2005-03-13 Thread Moderator
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

Re: [U2] Triggers docs?

2005-03-13 Thread Dan Fitzgerald
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?

2005-03-13 Thread Ross Ferris
: 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

[U2] Triggers docs?

2005-03-11 Thread Dan Fitzgerald
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. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Triggers docs?

2005-03-11 Thread David Scoggins
-users@listserver.u2ug.org Subject: [U2] Triggers docs? 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. --- u2-users mailing list u2-users

RE: [U2] Triggers docs?

2005-03-11 Thread Jay Falck
@listserver.u2ug.org Subject: [U2] Triggers docs? 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. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please

Re: [U2] Triggers docs?

2005-03-11 Thread Jeffrey Butera
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

RE: [U2] Triggers docs?

2005-03-11 Thread Scott Ballinger
] Triggers docs? 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. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http

RE: [U2] Triggers docs?

2005-03-11 Thread Adrian Matthews
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

RE: [U2] Triggers docs?

2005-03-11 Thread Scott Ballinger
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

RE: [U2] Triggers docs?

2005-03-11 Thread Jay Falck
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

RE: [U2] Triggers docs?

2005-03-11 Thread Scott Ballinger
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

RE: [U2] Triggers docs?

2005-03-11 Thread Adrian Matthews
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

RE: [U2] Triggers docs?

2005-03-11 Thread Adrian Matthews
: [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

RE: [U2] Triggers docs?

2005-03-11 Thread Martin Canty
Sent: Friday, March 11, 2005 10:15 AM To: u2-users@listserver.u2ug.org Subject: [U2] Triggers docs? 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. --- u2-users

RE: [U2] Triggers docs?

2005-03-11 Thread Ken Wallis
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