Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem with Select Statement
Message
De
19/11/2001 10:53:46
Alexandre Palma
Harms Software, Inc.
Alverca, Portugal
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00583460
Message ID:
00583466
Vues:
22
This message has been marked as the solution to the initial question of the thread.
Debra do the following

select distinct field1, field2 ;
from rawdata ;
where inlist(field2,&lcModString) ;
into table mytable

>I am trying to execute the following statement:
>
>select distinct field1, field2 ;
> from rawdata ;
> where inlist(field2,lcModString) ;
> into table mytable
>
>field2 is a 2 character field. lcModString will vary according to which check boxes are chosen on a form. What I am testing it with is a character string of '22','52'. When I replace lcModString in the above select statement with the literal '22','52' I have 1300 records returned. When I run the code above, I have 0 records returned. I have a feeling that the answer here is extrememly obvious, but those tend to be the most difficult problems for me to solve!
>
>TIA for your help.
Alexandre Palma
Senior Application Architect
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform