OraFAQ Forum: Forms » Updating table

Home » Developer & Programmer » Forms » Updating table

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

Updating table [message #492594]

Tue, 01 February 2011 06:32

electrosoul456
Messages: 6
Registered: October 2010
Location: pakistan

Junior Member

hi gurus i want to insert some data in the transactions table on after insert trigger could you please confirm me that which trigger should i use on form level to accomplish this task

Report message to a moderator

Re: Updating table [message #492612 is a reply to message #492594]

Tue, 01 February 2011 07:33

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

PRE-INSERT might be one choice. If you are committing by pressing a button you made, WHEN-BUTTON-PRESSED trigger. If you are committing by pressing a default toolbar "Save" icon, KEY-COMMIT. A database trigger might also be a way to do that.

Report message to a moderator

Re: Updating table [message #492616 is a reply to message #492612]

Tue, 01 February 2011 08:03

cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester

Senior Member

Littlefoot wrote on Tue, 01 February 2011 13:33

If you are committing by pressing a default toolbar "Save" icon, KEY-COMMIT.

That doesn't work you know. If you exit a form where changes have been made oracle will pop up an alert that asks you if you want to save changes. Clicking on yes saves the form without firing key-commit.

I'd go with pre-insert or a db trigger.

Report message to a moderator

Re: Updating table [message #492668 is a reply to message #492616]

Tue, 01 February 2011 12:55

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Honestly, that fact didn't cross my mind.

Report message to a moderator

Re: Updating table [message #492676 is a reply to message #492668]

Tue, 01 February 2011 13:52

cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester

Senior Member

I only make a point of mentioning it because I've been bitten by it.
Having the learnt that fact I can't work out what use key-commit could ever be.

Report message to a moderator

Previous Topic:	List Item Issue
Next Topic:	Copy Paste

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Sep 17 16:27:49 CDT 2024