how to select multiple records? [message #544619] |
Thu, 23 February 2012 01:40 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/9d3a737834daa8c057331fef1633aed5?s=64&d=mm&r=g) |
baliberde
Messages: 201 Registered: January 2012 Location: outer space
|
Senior Member |
|
|
Hello, I'd want to select multiple records in my multi-record block. I'd also want to do that with checkboxes. When the user clicks on a particular checkbox, that should be selected and whatever record the user wants to check it should be added to selected records. Any idea would be appreciated.
|
|
|
|
|
|
|
|
|
|
Re: how to select multiple records? [message #544643 is a reply to message #544642] |
Thu, 23 February 2012 03:09 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Right. It seems that you'll need to loop through the first block's records and CONCATENATE values (one by one) you find in checked records. I'd suggest you to do upon a button being pressed ("display selected records" - if that's a button) instead of immediate processing (i.e. when the checkbox is checked) because you might have a problem removing values when user de-selects previously selected record.
Just being curious - what will you do with the result?
[Updated on: Thu, 23 February 2012 03:09] Report message to a moderator
|
|
|
|
|
|
|
|
|
|
|
|
|
Re: how to select multiple records? [message #544666 is a reply to message #544663] |
Thu, 23 February 2012 03:59 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
cookiemonster
Messages: 13937 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
If you have checkboxes or list items or radio buttons and the value in the DB column doesn't match any of the values the form item recognizes it won't display the record.
You fix this by setting the mapping of other values property, or updating the DB data so that it does match a recognized value.
I always prefer the second option.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|