Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Multiple Items in parameterized view
Message
 
À
09/09/1998 03:52:58
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00134349
Message ID:
00134361
Vues:
13
>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

Try:

WHERE Notes.st_id $ Thisform.Vstring instead of IN.
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net

CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform