OraFAQ Forum: Forms » clear a record in master block & detail block

Home » Developer & Programmer » Forms » clear a record in master block & detail block (form builder 6i)

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

clear a record in master block & detail block [message #355152]

Wed, 22 October 2008 22:53

fadhzone
Messages: 61
Registered: April 2008

Member

hi All...

i'm facing a problem right now.
i have 2 block (master & detail block).
I wrote a script that allow user deletes a record in detail block, but now i want to let user delete record in master block but at the same time it will delete the details.
how can i do that...

thanks. Embarassed

Report message to a moderator

Re: clear a record in master block & detail block [message #355172 is a reply to message #355152]

Thu, 23 October 2008 00:31

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

Senior Member
Account Moderator

Why did you write a script? Forms enables you to delete records without any scripts; simply "remove record" by using the toolbar icon.

The same goes for both master and detail records - no script needed. Of course, you can not delete master record when detail records exist, unless you set the relation's "Delete record behavior" property to cascading. doing so, you'll remove both master and detail record(s).

Report message to a moderator

Re: clear a record in master block & detail block [message #355185 is a reply to message #355172]

Thu, 23 October 2008 00:56

fadhzone
Messages: 61
Registered: April 2008

Member

yeah i know..but i don't write the script at key_crerec, when i push clear button,it will clear out all my data at the form.

Report message to a moderator

Re: clear a record in master block & detail block [message #355188 is a reply to message #355152]

Thu, 23 October 2008 01:03

itech
Messages: 173
Registered: May 2008
Location: Fsd, Pakistan

Senior Member

Open your form, go to master block ==> Relations ==> Select relation and then press F4, set the delete behavior to cascade
and prevent master less operation to yes.

execute the form and check!

Report message to a moderator

Re: clear a record in master block & detail block [message #355198 is a reply to message #355185]

Thu, 23 October 2008 01:40

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

Senior Member
Account Moderator

fadhzone wrote on Thu, 23 October 2008 07:56

yeah i know..but i don't write the script at key_crerec, when i push clear button,it will clear out all my data at the form.

Nevertheless - no script is needed to do that (if you want to CLEAR the form, which is different from DELETING records). In that case, go to Action menu and select "Clear All".

Report message to a moderator

Re: clear a record in master block & detail block [message #355200 is a reply to message #355198]

Thu, 23 October 2008 02:02

fadhzone
Messages: 61
Registered: April 2008

Member

ok..it worked!!!

Thanks littlefoot & itech.
have a nice day!!

Report message to a moderator

Previous Topic:	Need jar file for Progress bar
Next Topic:	Migartion 6i to 10g - HTML files

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 27 18:28:03 CDT 2024