Home » Developer & Programmer » Forms » Custom problem : when validate record
Custom problem : when validate record [message #432013] Fri, 20 November 2009 07:03 Go to next message
moe_k
Messages: 18
Registered: November 2009
Location: Lebanon
Junior Member
hello .. im trying to customize an oracle form .. from the custom.pll

i want to save a record before entering a new record to a form.
i.e.
i dont want the user to enter a new record until he saves the record that he wrote ..
how can i do this using the when-validat-record?
please i really need a quick reply

i wrote:
if (event_name = WHEN-VALIDATE-RECORD)

then what?!


thanx!
Re: Custom problem : when validate record [message #432459 is a reply to message #432013] Tue, 24 November 2009 05:57 Go to previous messageGo to next message
coolbunny111
Messages: 12
Registered: June 2009
Junior Member
you should use "post_Record" trigger instead of when_Validate_Record;


You can write
commit;
next_Record 


in post_Record;

hope this will help
Smile Smile
Re: Custom problem : when validate record [message #432481 is a reply to message #432459] Tue, 24 November 2009 07:43 Go to previous message
cookiemonster
Messages: 12320
Registered: September 2008
Location: Rainy Manchester
Senior Member
coolbunny111 wrote on Tue, 24 November 2009 11:57
you should use "post_Record" trigger instead of when_Validate_Record;


You can write
commit;
next_Record 


in post_Record;

hope this will help
Smile Smile


It won't. They're both restricted procedures which you can't use in post-record. It helps to check solutions.

@moe_k

Does the record have to commited or will just posting it (applying it to the database but not commiting it so it can be rolled back) to be enough for your needs?
Previous Topic: rremove the top bar
Next Topic: change the name of the field
Goto Forum:
  


Current Time: Wed Sep 28 00:39:46 CDT 2016

Total time taken to generate the page: 0.10026 seconds