OraFAQ Forum: Forms » Clearing those records of a multirecord if the checkbox associated with them is unchecked

Home » Developer & Programmer » Forms » Clearing those records of a multirecord if the checkbox associated with them is unchecked (forms 6i)

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

Clearing those records of a multirecord if the checkbox associated with them is unchecked [message #286549]

Sat, 08 December 2007 02:21

venkatadeekshi
Messages: 17
Registered: October 2007

Junior Member

Hi,

I have a multirecord block with checkboxes. I need to clear all the records with unchecked checkboxes before committing the form.

for example the records are like this

project_ number request_number checkbox value

1000 1 'Y'
2000 2 'Y'
3000 3 'N'
4000 4 'Y'
5000 5 'N'

I want to clear those records with checkbox value 'N' before committing the form

Thanks & Regards

Report message to a moderator

Re: Clearing those records of a multirecord if the checkbox associated with them is unchecked [message #286743 is a reply to message #286549]

Mon, 10 December 2007 01:13

Maaher
Messages: 7065
Registered: December 2001

Senior Member

So, you'll have to change the ON-COMMIT event. Use the FIRST_RECORD, NEXT_RECORD and :SYSTEM.LAST_RECORD built-ins to create your logic.

MHE

Report message to a moderator

Re: Clearing those records of a multirecord if the checkbox associated with them is unchecked [message #288899 is a reply to message #286549]

Wed, 19 December 2007 00:42

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Have you solved your problem?

David

Report message to a moderator

Re: Clearing those records of a multirecord if the checkbox associated with them is unchecked [message #290205 is a reply to message #288899]

Thu, 27 December 2007 23:38

venkatadeekshi
Messages: 17
Registered: October 2007

Junior Member

Hi,

Thanks for your reply. The requirement has changed. So I didnt develop that code to clear the checkboxes.

Regards

Deekshit

Report message to a moderator

Previous Topic:	PL/SQL table in forms
Next Topic:	problem with synchronization between multirecord block fields

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 03 01:16:38 CST 2025