RE: [U2] Triggers on PICK flavor of UV

2008-11-20 Thread Horacio Pellegrino
27;u2-users@listserver.u2ug.org' Subject: RE: [U2] Triggers on PICK flavor of UV Which version of UV? Triggers have only recently worked on UV files. They used to only work on SQL-ized files. If you're not using SQL and haven't upgraded recently you may be on a version that's too

RE: [U2] Triggers on PICK flavor of UV

2008-11-20 Thread Anthony Youngman
.) Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Dallaire Sent: 20 November 2008 15:59 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Triggers on PICK flavor of UV Tom, Yes they are, we use them in our Pick UniVerse system. Mike Michael

RE: [U2] Triggers on PICK flavor of UV

2008-11-20 Thread Tom Dodds
John, thanks it was the ON EACH ROW that I was missing. It works now, thanks again Tom -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of john reid Sent: Thursday, November 20, 2008 10:11 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Triggers on

RE: [U2] Triggers on PICK flavor of UV

2008-11-20 Thread Tom Dodds
Thanks, now I have to go look further. Tom -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Dallaire Sent: Thursday, November 20, 2008 9:59 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Triggers on PICK flavor of UV Tom, Yes they are, we

RE: [U2] Triggers on PICK flavor of UV

2008-11-20 Thread Manu Fernandes
Hi, Yes, it run under PICK flavor, A trigger is not linked to the flavor of the current VOC, it is a definition into the header of the file. A subroutine is always executed into his compilation's flavor (from VOC wehre BASICed or $OPTIONS in source) Under PICK Flavor you must create a CATALOG

RE: [U2] Triggers on PICK flavor of UV

2008-11-20 Thread Mark Eastwood
Yes, at least on 10.1 they are. Which UV Release are you running? Mark -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Dodds Sent: Thursday, November 20, 2008 8:31 AM To: u2-users@listserver.u2ug.org Subject: [U2] Triggers on PICK flavor of UV Does

Re: [U2] Triggers on PICK flavor of UV

2008-11-20 Thread john reid
i get the same error, unless i use 'FOR EACH ROW CALLING' rather than 'CALLING'. Also, the 'called' trigger needs to be globally cataloged, ie '*UPCASE.IT' j On Thu, Nov 20, 2008 at 10:31 AM, Tom Dodds <[EMAIL PROTECTED]> wrote: > Does anyone know if Triggers are supported under the PICK flavor o

RE: [U2] Triggers on PICK flavor of UV

2008-11-20 Thread Mike Dallaire
Tom, Yes they are, we use them in our Pick UniVerse system. Mike Michael Dallaire Senior Applications Developer IBM Certified Solutions Expert Mortgage Builder Software, Inc. [EMAIL PROTECTED] Main: 800.850.8060 ext. 103 Fax:248.304.0601 www.mortgagebuilder.com Help Desk198 Confident