Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Vivek Deodhar
  Where is Vivek Deodhar?
 SANGLI
 India
 Vivek Deodhar
 To: Pratik Singh
  Where is Pratik Singh?
 Kota
 India
 Pratik Singh
 Tags
Subject: RE: Optimization Data Retreive
Thread ID: 393707 Message ID: 393808 # Views: 49 # Ratings: 2
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Tuesday, December 24, 2013 5:01:16 AM         
   


> THANKS BOTH
>
> i have also a issue please tell me where is mistake because when i run this query it shows error
>
> when i use where condition with customer.name like 'rajesh%' it shows result
> but when i use customer.name like ?thisform.text1.value+'%' it shows inputbox even i have also thisform.text1.value in form.
>
> if i fill rajesh in inputbox it shows also no result where is mistake
>
>
>
> note:  thisform.text1.value = 'rajesh'
> 
> 
> TEXT TO freshsearch ADDITIVE NOSHOW
> 	SELECT customer.name,customer.address,IFNULL(city.NAME,'') AS cityname,IFNULL(state.NAME,'') AS statename,
> 	IFNULL(country.NAME,'') AS coname
> 	FROM customer
> 	LEFT JOIN city ON customer.CITY = city.ID
> 	LEFT JOIN state ON city.STATE = state.ID
> 	LEFT JOIN country on customer.country = country.id
> 	WHERE customer.name LIKE ?thisform.text1.value+'%'
> ENDTEXT
> 
> IF SQLEXEC(mySqlConnection,m.FRESHSEARCH,'ABC') < 0
>    AERROR(aa)
>    =MESSAGEBOX(AA[1,2])
> ELSE
>    SELECT ABC
>    BROW NORMAL
> ENDIF
> 
> 
> Regards
> Pratik
> 
> 
> 
> 



Try this

 TEXT TO freshsearch ADDITIVE TEXTMERGE NOSHOW
 	SELECT customer.name,customer.address,IFNULL(city.NAME,'') AS cityname,IFNULL(state.NAME,'') AS statename,
 	IFNULL(country.NAME,'') AS coname
 	FROM customer
 	LEFT JOIN city ON customer.CITY = city.ID
 	LEFT JOIN state ON city.STATE = state.ID
 	LEFT JOIN country on customer.country = country.id
 	WHERE customer.name LIKE '<<thisform.text1.value>>%'
 ENDTEXT


Vivek

Live wisely... because in real world, there is no Ctrl + Z!

ENTIRE THREAD

Optimization Data Retreive Posted by Pratik Singh @ 12/22/2013 12:03:38 PM
RE: Optimization Data Retreive Posted by Anders Altberg @ 12/22/2013 5:29:15 PM
RE: Optimization Data Retreive Posted by Binod Binani @ 12/23/2013 10:00:20 AM
RE: Optimization Data Retreive Posted by Pratik Singh @ 12/23/2013 10:42:14 AM
RE: Optimization Data Retreive Posted by Anders Altberg @ 12/23/2013 11:01:28 AM
RE: Optimization Data Retreive Posted by Vivek Deodhar @ 12/24/2013 5:01:16 AM