OraFAQ Forum: Forms » Commit record automatically

Home » Developer & Programmer » Forms » Commit record automatically (Forms 6i)

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

Commit record automatically [message #447421]

Mon, 15 March 2010 04:36

arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates

Senior Member

I have a master detail form based on two tables and i want to save the record automatically when the user exits the last field.how i can do it.which trigger is appropriate and what is the code.

Report message to a moderator

Re: Commit record automatically [message #447427 is a reply to message #447421]

Mon, 15 March 2010 04:48

tamzidulamin
Messages: 132
Registered: October 2009
Location: Dhaka

Senior Member

use key-next trigger in the last_field of your data block.

Tamzidul Amin.

Report message to a moderator

Re: Commit record automatically [message #447436 is a reply to message #447427]

Mon, 15 March 2010 05:23

arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates

Senior Member

but what is that code.

Report message to a moderator

Re: Commit record automatically [message #447443 is a reply to message #447436]

Mon, 15 March 2010 05:43

javed.khan
Messages: 340
Registered: November 2006
Location: Banglore

Senior Member

DO_KEY('COMMIT_FORM');

Report message to a moderator

Re: Commit record automatically [message #447463 is a reply to message #447443]

Mon, 15 March 2010 06:32

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

Senior Member
Account Moderator

Why not simply

commit;

Report message to a moderator

Re: Commit record automatically [message #447464 is a reply to message #447463]

Mon, 15 March 2010 06:36

arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates

Senior Member

Do i need to use when :system.record_status = changed or something in key_next_item.

Report message to a moderator

Re: Commit record automatically [message #447468 is a reply to message #447464]

Mon, 15 March 2010 06:39

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

Senior Member
Account Moderator

No. Why would you? If you want to commit, commit!

Report message to a moderator

Re: Commit record automatically [message #447469 is a reply to message #447468]

Mon, 15 March 2010 06:41

arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates

Senior Member

thanks littlefoot for your prompt response but just in curiosity i want to know why to use this :system.record_status or otherwise in which situation i will be using it.Just a query ?

Report message to a moderator

Re: Commit record automatically [message #447470 is a reply to message #447469]

Mon, 15 March 2010 06:43

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

Senior Member
Account Moderator

Use it when you are interested in record's status. You don't care about it, so - don't check it either.

Read more about this system variable (as well as the others) in Forms Online Help System.

Report message to a moderator

Previous Topic:	Restricting entry from keyboard
Next Topic:	Oracle Form

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 03:34:26 CDT 2024