Home » Developer & Programmer » Forms » Multiple check box checked at a time.......
Multiple check box checked at a time....... [message #173242] Sat, 20 May 2006 15:38 Go to next message
imtiazmasud
Messages: 49
Registered: May 2005
Location: Bangladesh
Member
friends,
If it possible that multiple check-box can be checked at a time and based on that check box multiple data will be inserted into the database...if it is possible then reply me how..............please tell me with details...if possible by example then better.....imtiazmasud

Report message to a moderator

Re: Multiple check box checked at a time....... [message #173337 is a reply to message #173242] Sun, 21 May 2006 23:18 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
To action multiple check-boxes you need to 'scan' the rows that have been retrieved.

If the set of rows is short you do the following.
1) Store the current row number and the number of the first row currently displayed. Search the reference manual and this forum for 'top_record' and 'current_record'.
2) Go to the 'first_row'.
3) If the check-box is set, process the row.
4) If this is NOT the last row go to the next row. Repeat step 3 and step 4.
If this IS the last row then reset the screen by going to the stored 'top_record' and then going to the stored 'current_record'.

If the set of rows is very long then each time you set a check-box store the MINIMUM and MAXIMUM row number for a checked record. Then use the logic detailed above but starting at the minimum row and finishing at the maximum row.

David

Report message to a moderator

Previous Topic: how to capture an entry and use it in another form??
Next Topic: Mouse operations in oracle forms 10g
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 10:45:28 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.