OraFAQ Forum: Forms » Developer6i

Home » Developer & Programmer » Forms » Developer6i - Forms

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Developer6i - Forms [message #84121]

Sun, 01 February 2004 21:46

Sam
Messages: 255
Registered: April 2000

Senior Member

Hi,

I would request for some quick help from all you pundits.

I have a form module where I have a base table BLOCK, users can create/modify records in the base table. A simple COMMIT in the KEY-COMMIT written on the block level does the changes to the database.

Now a requirement has come where I have to make relevant changes(for each record in the base table block)�to a different table(some other table than the base table). The problem is that I am not able to find any trigger which fires for each record in the base table block after commit is issued.

Your early help/assistance will be truly appreciated.

Rgds,

Sam

�

�

�

Report message to a moderator

Re: Developer6i - Forms [message #84123 is a reply to message #84121]

Mon, 02 February 2004 05:10

magnetic
Messages: 324
Registered: January 2003

Senior Member

what you need is a databasetriger wich is different from triggers at block and item level.

you can creat databasetriggers in forms.
open the node schemas (not in your fmb file but at the bottom of the nodes in forms developer)
you will see oracle users.
find the table you want and creat a trigger.
you will see the choises you can make for your trigger to fire.

Report message to a moderator

Re: Developer6i - Forms [message #84135 is a reply to message #84123]

Tue, 03 February 2004 23:27

shankar
Messages: 29
Registered: January 2002

Junior Member

use: post-insert and post-update triggers in the forms, (block level)
or use backend triggers ( for each row) both post insert and post update fire for each row

Report message to a moderator

Re: Developer6i - Forms [message #84169 is a reply to message #84135]

Mon, 09 February 2004 15:07

prashant
Messages: 122
Registered: September 2000

Senior Member

I would do it by using database triggers rather than doing it from form coz if u try to do t from the form there r too many possibilities that it can and would go wrong.

thanks
Prashant

Report message to a moderator