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,CustLast FROM Customers +
UNION SELECT 'CUSTALL', ' All Customers ' 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
_____
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Friday, May 09, 2008 12:20 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Property commands to select all in listbox?
In 7.6. I have a Variable Lookup Listbox with a multi-select property set
on. I know going into the form how many rows there are in the ListBox, and
it cannot change once they're in the form.
The client wants to be able to click a button that says "select all", and
have all the rows actually highlighted so that they can then singly un-click
the few that they might NOT want to have selected. Anyone done this? I
was thinking that the only way to do it is to declare a cursor with
individual MAKECLICK commands. Not sure what that would look like on the
screen .... There is no MAKECLICKALL, is there?
Karen
