I am working on a program which allows users to select multiple items
from a listbox into another listbox. The program then passes all the
selected items in the second listbox to a variable (m.source) in a Select
FOR i=1 TO THIS.Chose.ListCount
SELECT * FROM JOURNAL WHERE jnsource in (m.source) INTO CURSOR result
The program returns only records of the first selected item. It seems
that SQL treats source as a single variable.
Does anyone know how to pass all the selected items to Select SQL?