Of Bill Haskett
Sent: 16 August 2011 20:25
To: U2 Users List
Subject: Re: [U2] UD - Triggers
So, are you saying if I have a trigger for CUSTOMER but not for
CUSTOMER,CUSTOMER then the trigger won't work if some code looks like:
TCL.CMD = \SELECT CUSTOMER WITH CLIENTNO = 6500 : @AM : \DELETE
CUSTOMER
: Re: [U2] UD - Triggers
So, are you saying if I have a trigger for CUSTOMER but not for
CUSTOMER,CUSTOMER then the trigger won't work if some code looks like:
TCL.CMD = \SELECT CUSTOMER WITH CLIENTNO = 6500 : @AM : \DELETE
CUSTOMER,CUSTOMER\ ; EXECUTE TCL.CMD CAPTURING OUTPUT?
H...
Bill
I have no problem with this on UD 7.2.
You do need to create the triggers e.g. DELETE on all partitions
CUSTOMER and CUSTOMER,NEWCUST and CUSTOMER,PREVCUST
CUSTOMER,CUSTOMER will also then be hit.
Similarly, if you put e.g. a DELETE trigger on CUSTOMER and
CUSTOMER,PREVCUST but not on
- Original Message -
*From:* mbr...@epicor.com
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 8/16/2011 1:53 AM
*Subject:* Re: [U2] UD - Triggers
I have no problem with this on UD 7.2.
You do need to create the triggers e.g. DELETE
] On Behalf Of Kevin King
Sent: Sunday, October 29, 2006 3:09 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] UD Triggers
What about DELETE.TRIGGER file BEFORE UPDATE?
-Kevin
[EMAIL PROTECTED]
http://www.PrecisOnline.com
** Check out scheduled Connect! training courses at
http
Does anyone know why I can't delete a trigger on a file in UniData
(v7.1 on NT)?
DELETE.TRIGGER file trigger BEFORE UPDATE
??? From your samples it looks like you're missing the BEFORE,
despite what the help says.
-Kevin
[EMAIL PROTECTED]
http://www.PrecisOnline.com
** Check out scheduled
Try either:
DELETE.TRIGGER APVENDOR UPDATE
Or
DELETE.TRIGGER APVENDOR BEFORE UPDATE
Larry Hiscock
Western Computer Services
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett
Sent: Saturday, October 28, 2006 11:56 AM
To:
12:25 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] UD Triggers
Does anyone know why I can't delete a trigger on a file in UniData
(v7.1 on NT)?
DELETE.TRIGGER file trigger BEFORE UPDATE
??? From your samples it looks like you're missing the BEFORE,
despite what the help says.
-Kevin
]
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Larry Hiscock
Sent: Saturday, October 28, 2006 12:30 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] UD Triggers
Try either:
DELETE.TRIGGER APVENDOR UPDATE
Or
DELETE.TRIGGER APVENDOR BEFORE UPDATE
Larry
I agree with his assessment for the most part but had some comments
to add as well.
At 04:46 PM 3/20/2006, Dave Taylor wrote:
We were under the impression IBM had conversion utilities available that
would mostly convert D3 style dictionaries to UD style dictionaries; thus
mitigating the one
[EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Sent: Friday, March 17, 2006 6:13 AM
Subject: RE: [U2] [UD] Triggers
snip
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
@listserver.u2ug.org
Subject: Re: [U2] [UD] Triggers
David,
I asked Bill Haskett recently why he chose to move this customer's software
from D3 to Unidata rather than to Universe, and he responded to me in
considerable detail.
Since I thought this might be of interest to you and others on the list, I
have
Agreed -- we have D3 users and UniData users and UniVerse users ... I'm not
sure that part of UniData is 'Time Warped' -- we've seen a ton of new
features built in during the last few years, while D3 chugs along, they've
only produced 3rd level point revisions in the last 2 years! Wow. It does
Ken:
...Original Message... from Ken Wallis
It sounds like you feel exactly the same about UniData as I
did about D3 when I spent a few months contracting at a D3
shop - antiquated stuff, how can anybody work with this when
xxx is so much better?
Yea. There's a lot about D3 that wears on
Some questions (I have a few sites that have this as an open topic as
well...) I meant to ask earlier, but couldn't figure out if I should Reply
or Reply All (kidding!!)
What was the driving force to move from D3 to UniData?
How difficult was the move - was it all green screen with source
David:
Answers below.
-Original Message-
From: David Wolverton
Sent: Thursday, March 16, 2006 11:36 AM
To: 'Bill Haskett'; u2-users@listserver.u2ug.org
Subject: RE: [U2] [UD] Triggers
What was the driving force to move from D3 to UniData?
According to our client:
1
] [UD] Triggers
David:
Answers below.
-Original Message-
From: David Wolverton
Sent: Thursday, March 16, 2006 11:36 AM
To: 'Bill Haskett'; u2-users@listserver.u2ug.org
Subject: RE: [U2] [UD] Triggers
What was the driving force to move from D3 to UniData?
According to our
Bill Haskett wrote:
How difficult was the move - was it all green screen with
source code or more difficult?
It wasn't that difficult. The biggest problems were UniData is like
interfacing with Microdata in 1982...it's a time warp! The UniData
environment is excruciatingly tedious and
Agreed - I never use the same code for both. The poster just asked
if it was possible and it is.
Just tweaking the idea, Jeff.. That's all.
-Kevin
[EMAIL PROTECTED]
http://www.PrecisOnline.com
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit
1) Can I create both an update and delete trigger on a file using the same
BASIC program or do I need to create two separate programs? In D3 there's
an internal function that indicates if the action is an add or delete. This
allows a single program to be used for both an update and a delete.
20 matches
Mail list logo