Re: v2.3 trigger logic in FORMS 4.5

In article <6ep04a$1pu$1_at_nnrp1.dejanews.com>,   Patrick.W.Lynch_at_fpc.com wrote:

Patrick,

We encountered these and other problems using V23 triggers in 4.5 (later than Release 1.1 of Dev2K). Our solution was to rewrite them in pl/sql. The only reason they existed was because they referenced database objects which may or may not exist and yet the form would still generate. We wrote the code using dynamic sql within the pl/sql and all is fine. Another reason to rewrite the code is that when you move on to newer versions of Dev2K, you won't be able to modify or even use V23 triggers.

Steven J. Quigley
Principal Technical Specialist
SCT Corp.

>
> I have found that after converting a 3.0 form to Oracle's Forms 4.5, using
> Oracle's generate utility, that my 2.3 triggers do not function the same in
> Forms 4.5 as they did under Sql*Forms 3.0. That is, the Success/Failure
 logic
> does not function the same. Under 3.0, if I have a step that tries to
 update
> a row that doesn't exist, the Failure step is taken. However, this same
> trigger in Forms 4.5 takes the Success branch. Does anyone know of some way
> to have Oracle Forms 4.5 behave the same as Sql*Forms 3.0 regarding these
 step
> triggers?
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Fri Mar 20 1998 - 00:00:00 CET