Re: Help: On Sql*Forms Trigger?

In article <CFzFo3.2o2w_at_austin.ibm.com> rrairao_at_austin.ibm.com writes:
>
> Question : I would like to delete a record ( row ) from the data ( eg:
> table xxx ) and insert that row into a table yyy which
> is
> similar to table xxx -- just to maintain a history
> records.
>
> I'm trying to write a trigger which uses cursors to do this task.
>
I don't believe you need to use cursors for this task. A simple Pre-Delete trigger at the block level should work.

Pre-Delete for block xxx:

        insert into yyy (col list) values (sysdate, :col1, :col2, ..., :colN);

(I think this example is in the SQL*Forms Designer's reference, but I would be hard-pressed to want to try to find anything in that monstrosity. :-).

Hope this helps.
Scott _at_ RPI. Received on Fri Nov 05 1993 - 16:41:25 CET