Home » Developer & Programmer » Forms » Commit record automatically (Forms 6i)
Commit record automatically [message #447421] Mon, 15 March 2010 04:36 Go to next message
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.
Re: Commit record automatically [message #447427 is a reply to message #447421] Mon, 15 March 2010 04:48 Go to previous messageGo to next message
tamzidulamin
Messages: 132
Registered: October 2009
Location: Dhaka
Senior Member
use key-next trigger in the last_field of your data block.

Tamzidul Amin.
Re: Commit record automatically [message #447436 is a reply to message #447427] Mon, 15 March 2010 05:23 Go to previous messageGo to next message
arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates
Senior Member

but what is that code.
Re: Commit record automatically [message #447443 is a reply to message #447436] Mon, 15 March 2010 05:43 Go to previous messageGo to next message
javed.khan
Messages: 340
Registered: November 2006
Location: Banglore
Senior Member

DO_KEY('COMMIT_FORM');
Re: Commit record automatically [message #447463 is a reply to message #447443] Mon, 15 March 2010 06:32 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Why not simply
commit;
Re: Commit record automatically [message #447464 is a reply to message #447463] Mon, 15 March 2010 06:36 Go to previous messageGo to next message
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.

Re: Commit record automatically [message #447468 is a reply to message #447464] Mon, 15 March 2010 06:39 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
No. Why would you? If you want to commit, commit!
Re: Commit record automatically [message #447469 is a reply to message #447468] Mon, 15 March 2010 06:41 Go to previous messageGo to next message
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 ?
Re: Commit record automatically [message #447470 is a reply to message #447469] Mon, 15 March 2010 06:43 Go to previous message
Littlefoot
Messages: 20891
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.
Previous Topic: Restricting entry from keyboard
Next Topic: Oracle Form
Goto Forum:
  


Current Time: Sat Dec 03 19:55:18 CST 2016

Total time taken to generate the page: 0.20518 seconds