ListOf is perfectly OK as long as the result doesn't exceed the largest
variable (note) length.  Like my example at the Spring Converence with tens of
thousands (41,000 +) items added in a few seconds, ListOf wouldn't work to
well....

----- Original Message ----- 
From: "Charles Parks" <[EMAIL PROTECTED]>
To: "RBG7-L Mailing List" <[EMAIL PROTECTED]>
Sent: Monday, November 29, 2004 8:36 AM
Subject: [RBG7-L] - Re: CHKBOX funtionality in Forms


Is there one method of loading the user defined listbox that is better
or is it just programmer choice?

I found this method also works
   SELECT (listof(Sys_Table_Name)) INTO vSysTables INDICATOR viSysTables
FROM Sys_Tables
   PROPERTY lbTables LISTITEMSCLEAR 'TRUE'
   PROPERTY lbTables LISTITEMS .vSysTables

I have also found clicking the right mouse button before releasing the
left mouse button will allow the multiselect to work with user defined
listboxes with an expression.   Using the other 3 load methods doesn't
require the right mouse button to be clicked which makes it more user
friendly.

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MikeB
Posted At: Thursday, November 25, 2004 2:12 PM
Posted To: RB7-L
Conversation: [RBG7-L] - Re: CHKBOX funtionality in Forms
Subject: [RBG7-L] - Re: CHKBOX funtionality in Forms




> Thanks, Mike, but please could you do me a favour and either re-post
> or send me privately that example?
>
> Also, I have been experimenting today with a "Variable LookUp Listbox"

> but you talk of a "User Defined Listbox" - will your solution work on
both?

http://www.byerley.net/multiSelectForm.zip This is the Example I was
referring.

This Only works on a Variable User Defined ListBox, but there is nothing
that
*Can't* be done using it, except employ the MultiSelect when you use
Expressions for Lookups.

In other words, just use a Declare Cursor and the ListItemsADD Property
to populate the ListBox or do a Select to a file on disk, and use the
Load_From_File property to populate it.

Then MultiSelect works perfectly.


>
> Regards,
> Alastair.

Reply via email to