----- Original Message -----
From: <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Monday, May 12, 2008 6:10 PM
Subject: [RBASE-L] - Re: Property commands to select all in listbox?
> Bill: I appreciate all suggestions!
>
> However, this doesn't help with what I need. If there's 100 things in the
> listbox, and they want 90 of them, they have to click 90 times. I already
> have
> a button to "select all items" -- they don't even have to click into the list
> box to do that. But listbox multi-select doesn't support shift-clicking to
Yes it does. It just doesn't work when you bind it to a table as a lookup
using a column expression.
If you add "Items" manually from the ListBox property dialog box or add them on
the fly LISTITEMSADD or Load_From_File, it behaves as it should.
if you select an item in the ListBox and THEN press and hold Shift, then either
scroll down (if the last selection is beyond the listbox view limit) to the
last contiguous item and click on it, THEN release the shift key..
Everything in between will be SELECTED.
While items are SELECTED, if you press and hold the CTRL key you can DESELECT
any SELECTED item or Add an UNSELECTED item to the SELECTED items. I swear
this is true....
> grab contiguous ranges, or a hot-key that I know of (like I think it was
> shift-F6 or something to select all from a check box menu?)
>
> Alastair: we've decided that the 2 buttons "process all selected" and
> "process all EXCEPT those selected" would probably lead to too many user
> errors.
> I'm working with Jan on his idea -- to add a Y/N field to my temp table,
> represent with images, and on-click eeps to turn the Y/N on and off, a button
> to turn
> them all on/off... Pretty slick once I get it polished, I think.
>
> Karen
>
>
>
>> Karen,
>>
>> Sorry for jumping in on this issue so late but I may have a workaround for
>> you.
>>
>> Create a table called AllThings with one column (AllThings Text 40)
>> Load this table with 1 item ('AllThings')
>>
>> Create a view that includes the items your client wants in the listview.
>> I created this view to include a choice for 'All Customers'
>>
>> DROP VIEW `CustPick`
>> CREATE VIEW `CustPick` +
>> (CustId,CustName) AS +
>> SELECT CustId,CustLastFROM Customers+
>> UNION SELECT 'CUSTALL', ' AllCustomers' FRO ALLTHINGS WHERE LIMIT = 1
>> RETURN
>>
>> Note that there is a space in front of the phrase ' All Customers'. In this
>> way All Customers will always be at the top of the list.
>>
>>
>> Make your listview lookup based on the view CustPick and order by CustLast
>> (or custname or whatever you use)
>> This would produce a view that looks like this;
>>
>> All Clients
>> 1234 Adams Corp
>> 1235 Baker Company
>> 1236 Charles Inc.
>> 1237 Delta Co Inc.
>> 1238 Edwards LLC
>> etc.
>>
>> Then in my follow-up code if the choice is CUSTALL then I do some code. If
>> the choice is not CUSTALL, then you use your code for the multiple selects.
>>
>> Whats nice about this is you can create any number of listviews for any
>> number of tables where you need to select ALL of something from a list.
>>
>> Then, of course, if Razzak has already come up with a slick update, then
>> forget this.
>>
>> Hope this helps.
>>
>> Bill Eyring
>>
>
>
