Path: utzoo!utgpu!jarvis.csri.toronto.edu!mailrus!tut.cis.ohio-state.edu!ucbvax!decwrl!hplabs!hp-sdd!ncr-sd!ncrlnk!ncrwic!cetc!crand
From: crand@cetc.Wichita.NCR.COM (Collette Rand)
Newsgroups: comp.databases
Subject: Re: using triggers in pc oracle forms
Keywords: triggers help please
Message-ID: <1005@cetc.Wichita.NCR.COM>
Date: 13 Feb 89 14:09:05 GMT
References: <7606@xanth.cs.odu.edu>
Reply-To: crand@cetc.UUCP (Collette Rand)
Organization: NCR Corporation, Wichita, Kansas
Lines: 37
Summary:EXEMACRO Triggers only for Keys

In article <7606@xanth.cs.odu.edu> paterra@xanth.cs.odu.edu (Frank C. Paterra) writes:
>Hello Netlanders,
>
>I'm having a problem with sqlforms on the pc version of oracle.  Every
>things seems to work ok until I use a trigger that has a #EXEMACRO
>statement in it.  I've tried #exemacro exeqry, #exemacro nxtblk, and
>lots of others, but whenever it gets to the #exemacro statement
>I get the error "SQL error in processing post-field trigger".  I've tried
>using post-field, post-change, and pre-field triggers, but the result
>is the same.  
>
>My company did not purchase the telephone support so oracle can't give
>me any help.  What might I be doing wrong??
>
>Thanks for the help
>Frank Paterra
>paterra@xanth.cs.odu.edu


Frank, 

As far as I understand it, #EXEMACRO statements can only be used 
to redefine keys, except for macros that take arguments.

The only macro function codes that take arguments are:
 CALL, CALLQRY, CASE, EXETRG, and NULL.
 (GOBLK and GOFLD take arguments but are not included in this
  group.)

I got this information out the the SQL*Forms Class Notes.
I hope this helps you.

-- 
Collette Rand      |  NCR: 530-4741   (316) 636-4741 C.Rand@Wichita.NCR.COM
NCR - CETC         |  <{ece-csc,hubcap,gould,rtech}!ncrae!ncrwic!crand
3450 N. Rock Rd.   |  <{sdcsvax,cbatt,dcdwest,nosc.ARPA,ihnp4}!ncr-sd!
Wichita, KS  67226 |              ncrwic!crand