Home » Developer & Programmer » Forms » Clearing those records of a multirecord if the checkbox associated with them is unchecked (forms 6i)
Clearing those records of a multirecord if the checkbox associated with them is unchecked [message #286549] Sat, 08 December 2007 02:21 Go to next message
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
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 Go to previous messageGo to next message
Maaher
Messages: 7062
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
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 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you solved your problem?

David
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 Go to previous message
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
Previous Topic: PL/SQL table in forms
Next Topic: problem with synchronization between multirecord block fields
Goto Forum:
  


Current Time: Sun Dec 04 18:50:17 CST 2016

Total time taken to generate the page: 0.04479 seconds