Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Multiple Items in parameterized view
Message
De
09/09/1998 03:52:58
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Multiple Items in parameterized view
Divers
Thread ID:
00134349
Message ID:
00134349
Vues:
48
I have a multi select listbox that I loop thru and create a string of ID's of the selected items. For example, lets say that there are three items selected in the listbox. The string would look like this:

"AAAAAb,AAAAAH,AAAAAc"

I store this value to a form property i.e. THISFORM.VSTRING

In the View Designer, my view looks like this:

SELECT Notes.no_id, Notes.co_id, Notes.recordkey, Notes.nn, Notes.sn,;
Notes.name, Notes.contdate, Notes.note, Notes.phone, Notes.callback,;
Status.st_status, Notes.st_id;
FROM planetrk!notes INNER JOIN planetrk!status ;
ON Notes.st_id = Status.st_id;
WHERE Notes.st_id IN (?THISFORM.VSTRING);
ORDER BY Notes.co_id, Notes.name, Notes.contdate DESC

I'm doing something wrong, 'cause I'm not getting the 3 ID's that I
want.

What am I doin' wrong?

Best
Dave
Best
Dave
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform