OraFAQ Forum: Forms » Custom problem : when validate record

Home » Developer & Programmer » Forms » Custom problem : when validate record

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

Custom problem : when validate record [message #432013]

Fri, 20 November 2009 07:03

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!

Report message to a moderator

Re: Custom problem : when validate record [message #432459 is a reply to message #432013]

Tue, 24 November 2009 05:57

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

Report message to a moderator

Re: Custom problem : when validate record [message #432481 is a reply to message #432459]

Tue, 24 November 2009 07:43

cookiemonster
Messages: 13963
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

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?

Report message to a moderator

Previous Topic:	rremove the top bar
Next Topic:	change the name of the field

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Feb 04 05:11:06 CST 2025