Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Yuri Rubinov
  Where is Yuri Rubinov?
 Pennsylvania - United States
 Yuri Rubinov
 To: John Discallar
  Where is John Discallar?
 John Discallar
Subject: RE: Record Selection
Thread ID: 16288 Message ID: 16312 # Views: 1 # Ratings: 0
Version: Unknown Category: General VFP Topics
Date: Wednesday, October 16, 2002 3:33:28 PM         

Try this:
?sqlexec(gnConnHandle, "Select * from table_name where left(field_name,1) IN ('A','M','Z')")

> Hi All,
> I have an existing listbox , which the user wants to customize it's content, for example, the user is specifically assigned to suppliers starting from A,M,Z
> he wants to have a listing that constains only the criteria that they have set (A,M,Z).
> My Initial approach is to do a separate select statement on those criterias, & then populate the listbox after another
> but i'm wondring if there are other possible solution in which you could ask the database to do
> multiple criteria selection.
> I know this is possible on DBF via "$" , but how about on SQLEXEC?
> Hope you could help me ....
> Best Regards,
> Foxpro Child


Record Selection Posted by Caij Gomez @ 10/16/2002 5:10:08 AM
RE: Record Selection Posted by Yuri Rubinov @ 10/16/2002 3:33:28 PM