Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with Select Statement
Message
From
19/11/2001 10:53:46
Alexandre Palma
Harms Software, Inc.
Alverca, Portugal
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00583460
Message ID:
00583466
Views:
21
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform