Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Saifuddin Hussain
  Where is Saifuddin Hussain?
 Dubai
 United Arab Emirates
 Saifuddin Hussain
 To: llyrad atsituab
  Where is llyrad atsituab?
 Tacloban City
 Philippines
 llyrad atsituab
 Tags
Subject: RE: Filter Record
Thread ID: 373334 Message ID: 373386 # Views: 30 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Thursday, March 21, 2013 9:05:35 PM         
   


> > Hi
> >
> > How to filter record or using SQL-select like the following:
> >
> >
> >
Select pcode As pcode,Lpo as Lpo,sono as Sono,sodate as sodate,location as Location From somain ;
> >     WHERE Upper(CustLoca.pcode) = Upper(m.cDisplayValue) and ('&m.cDisplayValue')$lpo INTO Cursor TmpCust
> > 

> >
> > whereas CDisplayValue = 'CC021C' and LPO = 198333562'
> >
> > Now, I want to filter record through LPO and want to seek only 833. How can I do so?
> >
> > Saifuddin
>
> by using like %m.variable% where variable is the data that will be filtered..
>
> Regards:
> carbcoder_02

Thanks a lot Mr.Ilyrad for the reply. It works only if I hard coded with '833' if I use like the following it is not working.

cDisplayValue = Alltrim(Upper(This.Value))
Select pcode As pcode,Lpo as Lpo,sono as Sono,sodate as sodate,location as Location From somain ;
    WHERE Upper(CustLoca.pcode) = Upper(m.cDisplayValue) and LPO LIKE "%m.cDisplayValue%" INTO Cursor TmpCust

Saifuddin

ENTIRE THREAD

Filter Record Posted by Saifuddin Hussain @ 3/21/2013 11:16:10 AM
RE: Filter Record Posted by llyrad atsituab @ 3/21/2013 1:07:14 PM
RE: Filter Record Posted by Saifuddin Hussain @ 3/21/2013 9:05:35 PM
RE: Filter Record Posted by Tamar Granor @ 3/21/2013 9:27:39 PM
RE: Filter Record Posted by Saifuddin Hussain @ 3/21/2013 9:51:30 PM
RE: Filter Record Posted by Jun Tangunan @ 3/22/2013 6:12:41 AM
RE: Filter Record Posted by Saifuddin Hussain @ 3/22/2013 11:15:28 AM
RE: Filter Record Posted by Saifuddin Hussain @ 3/22/2013 1:18:29 PM