Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>I am having to compare a string with a multiple selected items from a list box.
>Ex:
>
>select all a.cname, b.csemester, b.cccourse, b.cstudent from sysMast a, enroll b where rtrim(b.semester) == thisform.listBox.value(this is a multiple selection list box and I am having to compare
>rtrim(b.semester) with all the item selected in the list box)
>
>How can you do this? can you do a some kind of loop in the select statement.
>
>Thank you for any help
I don't think loops are possible.
But you can make a loop to fill in a cursor with the selected items.
Then you can use that cursor for your SQL view.
You also ca do this with a multiselectgrid (grid with a check field).
Posible there is one n the files section.
Hope this helps you
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement