,
building the query string via the loop was the key. Glad its working.
:-)
-Original Message-
From: Mayer, Mike @ Vancouver [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 04, 2005 4:37 PM
To: Nabors, Steve
Cc: 'mapinfo-l@lists.directionsmag.com'
Subject: RE: MI-L MultiListBox Values
Yes
.
Thanks Again!
Mike
-Original Message-
From: Nabors, Steve [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 05, 2005 7:50 AM
To: Mayer, Mike @ Vancouver
Cc: mapinfo-l@lists.directionsmag.com
Subject: RE: MI-L MultiListBox Values
OK,
I see, you want to present the query table itself, not a second
]
Sent: Tuesday, May 03, 2005 12:55 PM
To: Nabors, Steve
Subject: RE: MI-L MultiListBox Values
Steve,
Thank you for your response, I appreciate the input. I got it working,
however, in theDescriptionTable, I only get one of the values (the last one)
selected. Is there a way to add each item
, Steve [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 04, 2005 2:33 PM
To: Mayer, Mike @ Vancouver
Cc: mapinfo-l@lists.directionsmag.com
Subject: RE: MI-L MultiListBox Values
I'm trying to understand your logic. Are you wanting to take selections
made in the first multilistbox, put them into a new
'Make your RetailMuniHandler Sub do something like the following
'Note that AnOpenTable is an open table that has a field called Description
that has values in it matching 'marrMunicipality values
dim Pos as integer
Pos = ReadControlValue(1)
'Here we need a loop to hop thru each selection
Hi Peter,
The ReadControlValue() used on a MultiList Control will return 0 if no items
were selected and when all selected items have been read.
I thing that also can be tricky is that if you have a handler on you dialog
that reads which item was selected in your MultiListbox this also seem to
Sara
I asked a similar question a few weeks ago and received an example that
worked perfectly from Peter Zyczynski. My question was in regards to
reading what was selected and putting this into a string to be used in an
SQL query. I have copied the reply I received. The key is to use an the
In your control handler, everytime you call ReadControlValue(1) (assuming
your MultiListBox is assigned ID 1), an integer will be returned indicating
the selection, until you finally get a 0. Call ReadControlValue in a loop.
For example:
Dim Pos As Integer
Pos =
