Path: utzoo!attcan!uunet!mcvax!unido!tub!astbe!ber
From: ber@astbe.UUCP (H.Bernau)
Newsgroups: comp.databases
Subject: Re: using triggers in pc oracle forms
Keywords: triggers help please
Message-ID: <505@astbe.UUCP>
Date: 13 Feb 89 06:57:16 GMT
References: <7606@xanth.cs.odu.edu>
Reply-To: ber@astbe.UUCP (H.Bernau)
Organization: GEI Software Technik Berlin, Germany
Lines: 32

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.  

Hello Frank,

sorry that I'm not replying via mail but our local sendmail doesn't understand
your adress.

As stated in the SQL*Forms Designer's Reference Manual you are not allowed
to use trigger steps that will cause a cursor movement in 
{pre,post}-{field,record,block,form} triggers. Look at the manual to see what
kind of trigger steps are allowed.

Hope this will help you

Rolf

-------------------------------------------------------------------------------
|   Rolf Bernau               |
|   GEI Software Technik mbH  |  Berlin:             astbe!ber
|   Hohenzollerndamm 150      |  USA:                ...!pyramid!tub!astbe!ber
|   1000 Berlin 33            |
|   West-Germany              |
-------------------------------------------------------------------------------