 |
BorlandTalk.com
Borland discussion newsgroups
|
| View previous topic :: View next topic |
| Author |
Message |
Esteban Pacheco
Guest
|
 Posted: Sun May 13, 2007 8:12 am Post subject: Who has this component or where to look for it? |
 |
|
Hello guys,
Basically I want to have a check box list, that displays all the possible
values from a lookup table, then depending on the options checked, those
values will be persisted on a table that contains pairs with the format
<SomeKeyID, LookUpTableKeyID>.
Another example:
LookUpTable:
TypeID, Description
SelectionsTable:
SomeID, LookUpTableTypeID
CheckList Box displays <Description> from the LookUp Table and keeps its
TypeID, then once all the selections are done, it persists those selections
in the target SelectionsTable, assume SelectionID is a key that already
exists or its an autoincremental.
Anyone aware of this kind of checklistbox? seems to be pretty common,
instead of using the awkward dialog with 2 checklist box and the [>] and [<]
buttons, that take space and are not that friendly?
I dont know if I was clear enough, so, let me know if it rings a bell or i
need to verbose more.
Att.
Esteban Pacheco
http://blogs.epachsoft.com |
|
| Back to top |
|
 |
Barry
Guest
|
| Posted: Wed May 16, 2007 8:13 am Post subject: Re: Who has this component or where to look for it? |
|
|
On Sun, 13 May 2007 02:49:27 -0400, "Esteban Pacheco" <lastboyscout (AT) hotmail (DOT) com> wrote:
| Quote: | Anyone aware of this kind of checklistbox? seems to be pretty common,
instead of using the awkward dialog with 2 checklist box and the [>] and [<]
buttons, that take space and are not that friendly?
I dont know if I was clear enough, so, let me know if it rings a bell or i
need to verbose more.
|
Esteban
To get all possible values from the table, you need to use SQL to load the values into the
listbox. (Use Select Distinct if the values are not distinct). Then depending on which items are
checked, build a filter or a Where clause for the primary table. There are many check list boxes
available for Delphi.
http://delphi.about.com/od/delphitips2007/qt/listviewchecked.htm
http://www.torry.net/quicksearchd.php?String=listbox&Title=Yes
I would probably build the filter/query as soon as a checkbox is clicked on. That way the user can
see the filtered results right away without having to wait to push a filter button.
Barry
-----------------------------------
e-mail: support (AT) NOSPAMgrebarsys (DOT) com
web page: http://www.grebarsys.com
PrintDAT! - Make your grids and tables printable in just 10 seconds & 1 line of code
SuperFastDistinct! - 5x, 10x, 100x faster than SQL's Select Distinct ... |
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
