Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
combo box question?
- Thread starter asm338s
- Start date
- Thread starter
- #3
How would I check to see which values are selected in the listbox when running my sql queries.
Select * from table1 where INLIST(table1.column1, 'value1', 'value2') into.....
*value1 and value2 are multiple values selected by the user from the list
Select * from table1 where INLIST(table1.column1, 'value1', 'value2') into.....
*value1 and value2 are multiple values selected by the user from the list
First, unless you know that the user can only select 24 or less items, I wouldn't use INLIST. Rather create a cursor with the selected values. Then:
Select * from table1 where ;
table1.column1 IN (SELECT * from mycursor) ;
INTO ...
To process the multiple selected items into the cursor, see the VFP help file for the ListBox Property Multiselect for some sample code.
Rick
Select * from table1 where ;
table1.column1 IN (SELECT * from mycursor) ;
INTO ...
To process the multiple selected items into the cursor, see the VFP help file for the ListBox Property Multiselect for some sample code.
Rick
- Status
