Re: SQL*FORMS Help Needed

In article <2153_at_hal.CSS.GOV>, nancie_at_hal.CSS.GOV (Nancie Marin) writes:

>I'm trying to design an SQL form and I have run into a
>problem concerning triggers. I would like to re-define
>the INSERT syntax used by FORMS for inserting a record
>into the database (i think).
>
>
>Is there a way to override the default INSERT information
>with a trigger? I've read over the documentation in the
>Designer's Reference Manual, but there is no mention of
>a way to re-define the action taken for inserting a
>row, only that you can execute triggers to happen both
>before and after the insert.
 

>I am using SQL*FORMS Version 2.3 on a Sun SPARCstation 1.THANKS!

I was doing fine until you said you were running Version 2.3 of SQL*Forms. In version 3.0 you can use an On-Insert trigger to replace the "normal" insert functionality. But you're sort of stuck under 2.3 (By the way, if there's any way you can, I really recommend moving to 3.0. It's a lot easier to work with, it's got some additionaly flexibility, and you don't have to convert your existing 2.3 triggers (you can mix and match triggers in 3.0)). Anyway, you might try some sort of pre-insert trigger (i.e delete the row you just added, then turn around and insert the real rows, or just add the additional rows as part of the insert.

                                        Hope this helps,

                                                judie    Received on Mon Oct 26 1992 - 22:27:12 CET