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: [email protected] Subject: Re: [U2] Triggers on PICK flavor of UV 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 of > UniVerse. > > > >>CREATE TRIGGER UPCASE BEFORE INSERT OR UPDATE ON HTTEST CALLING UPCASE.IT; > > Statement triggers are not supported. > > > > If they are not, does anyone know a cleaver way around it other than > writing your own? > > > > Thanks in advance > > > > Tom > ------- > u2-users mailing list > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ > -- john ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ __________ Information from ESET NOD32 Antivirus, version of virus signature database 3627 (20081120) __________ The message was checked by ESET NOD32 Antivirus. http://www.eset.com ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
